A fix is available
APAR status
Closed as new function.
Error description
SQLGetData() when fetching XML data into SQL_C_WCHAR
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of Db2 12 for z/OS * * ODBC/CLI driver when fetching XML data * * into SQL_C_WCHAR WITH LIMITEDBLOCKFETCH=1. * **************************************************************** * PROBLEM DESCRIPTION: * * SQLGetData() issues SQLSTATE=07006 * * ERRLOC=4:68:1 SQLCODE=-99999 * * when fetching XML data into * * SQL_C_WCHAR. * **************************************************************** * RECOMMENDATION: * **************************************************************** When fetching XML data into SQL_C_WHCAR with LIMITEDBLOCKFETCH enabled, SQLGetData() failed with SQL_ERROR. SQLGetDiagRec will show the following detailed error information: {DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=07006 ERRLOC=4:68:1 The following example illustrates the problem: 1. Set LIMITEDBLOCKFETCH=1 in the ODBC INI file. 2. Prepare and execute a SELECT statement to return a SQL_XML column. Leave the result set column unbound. 3. Issue SQLGetData() to fetch from the result set column into SQL_C_WCHAR. - SQLSTATE 07006 is returned.
Problem conclusion
Temporary fix
Comments
SQLGetData() has been changed to correctly fetch XML data into SQL_C_WCHAR.
APAR Information
APAR number
PH30575
Reported component name
DB2 ODBC/JDBC/S
Reported component ID
5740XYR02
Reported release
C17
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-10-14
Closed date
2020-12-03
Last modified date
2021-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72917
Modules/Macros
DSNAOC27 DSNAOSDK DSNAOG27 DSNAOCLI
Fix information
Fixed component name
DB2 ODBC/JDBC/S
Fixed component ID
5740XYR02
Applicable component levels
RC17 PSY UI72917
UP20/12/15 P F012
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C17"}]
Document Information
Modified date:
05 March 2021