PM43179: SQLCODE -171 DURING BIND USING A FILE REFERENCE HOST VARIABLE OF XML DATATYPE IN AN APP PREPARED BY THE DB2 COPROCESSOR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• COBOL pgm, while doing a BIND with an INSERT from XMLTABLE
  and a hostvar in query is a CLOB type, results in SQLCODE171
  from DSNXOTDA SQLCODE  -171 SQLERRD1 -666
  
  Both DB2 and COBOL compiler have code change to fix this
  problem, so there is also APAR PM43791 for COBOL.
  is used in an application prepared by the DB2 coprocessor, DB2
  may issue an unexpected SQLCODE -171 during BIND. Both DB2 and
  COBOL have a code change to fix this problem for a COBOL
  application, so there is also APAR PM43791 for the COBOL
  compiler.
  SQLOCDE171 is issued from DSNXOTDA with SQLERRD1 -666.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 coprocessor for z/OS        *
  *                 using file reference variables for XML data  *
  *                 types (XML AS CLOB-FILE, XML AS BLOB-FILE,   *
  *                 or XML AS DBCLOB-FILE host variable in a     *
  *                 COBOL application, XML AS CLOB_FILE,         *
  *                 XML AS BLOB_FILE, or XML AS DBCLOB_FILE      *
  *                 host variable in a C/C++ or PLI              *
  *                 application).  910 A10                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: For a file reference host variable      *
  *                      with XML data type (XML AS CLOB-FILE    *
  *                      XML AS BLOB-FILE or XML AS DBCLOB-FILE  *
  *                      in a COBOL application,                 *
  *                      XML AS CLOB_FILE, XML AS BLOB_FILE      *
  *                      or XML AS DBCLOB_FILE in a C/C++ or     *
  *                      PLI application), DB2 may incorrectly   *
  *                      issue SQLCODE -171 during               *
  *                      bind time.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following COBOL example illustrates the problem:
  01 HV-XML-CLOB-FILE SQL TYPE IS XML AS CLOB-FILE.
     EXEC SQL
       INSERT INTO T1 (DOCID, DOC)
       SELECT X.ID, XMLDOCUMENT(X.DOC)
       FROM XMLTABLE('//item' PASSING :HV-XML-CLOB-FILE
              COLUMNS
                ID  INTEGER  PATH 'itemID',
                DOC XML      PATH '.'
            ) AS X
     END-EXEC.
  
  When binding the DBRM generated by the DB2 coprocessor,
  DB2 incorrectly issues SQLCODE -171.
  COBOL APAR PM43791 is required as well as this DB2 APAR to
  fix the problem in a COBOL application.
  
  Additional keywords: DB2COPROCESSOR SQLCODE171 SQLHOSTVAR SQLLOB
  

Problem conclusion

• The DB2 coprocessor code is modified so that the unexpected
  SQLCODE -171 is not issued for the valid use of a file
  reference variable with XML data type.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK71136 UK71137

Modules/Macros

• DSNHPSRV
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK71136

     UP11/09/13 P F109

• R910 PSY UK71137

     UP11/09/13 P F109

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.