A fix is available
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 number
PM43179
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-07-07
Closed date
2011-08-23
Last modified date
2011-10-03
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 October 2011