PH30575: ODBC SUPPORT FOR PYTHON IBM_DB

Obtain the fix for this APAR.

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 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.