PI17179: SQLCODE203 IS ENCOUNTERED WHEN CLI APPLICATION CALLS DBMD SP SYSIBM.SQLPRIMARYKEYS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE203 is encountered when CLI application calls DBMD SP
  SYSIBM.SQLPRIMARYKEYS. Subsequent call to SYSIBM.SQLSTATISTICS
  receives a CLI0115E error message.
  
  The following sample SQL receives the SQLCODE203:
  SELECT  'XXXXXXXXXX'  AS TABLE_CATALOG, RTRIM(TBCREATOR)
  AS TABLE_SCHEMA, TBNAME AS TABLE_NAME, NAME AS
  COLUMN_NAME, CAST(NULL AS VARCHAR(16)) AS COLUMN_GUID,
  CAST(NULL AS INTEGER) AS COLUMN_PROPID, CAST(KEYSEQ
  AS INTEGER) AS ORDINAL, CAST(NULL AS VARCHAR(128))
  AS PK_NAME FROM SYSIBM.SYSCOLUMNS C , SYSIBM.SYSTABLES T
  WHERE C.KEYSEQ > 0 AND C.TBCREATOR = T.CREATOR AND
  C.TBNAME = T.NAME AND T.DBNAME =  'AAAAAAA 'AND
  C.TBCREATOR = ? AND C.TBNAME = ? ORDER BY 1, 2, 3 FOR
  FETCH ONLY WITH UR
  
  ADDITIONAL KEYWORDS/SYMPTOMPS:
  ==============================
  Database MetaData Stored Procedures
  TBCREATOR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the CLI Driver provided with    *
  *                 DB2 for Linux, Unix, and windows version 8   *
  *                 and above that connect to DB2 10 for z/OS    *
  *                 or DB2 11 for z/OS.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Stored procedure SYSIBM.SQLPRIMARYKEYS  *
  *                      returns an SQLCODE203 when called from  *
  *                      OLE DB applications with keyword DBNAME *
  *                      through the CLI driver.                 *
  ****************************************************************
  * RECOMMENDATION: Apply the fixing PTF for this APAR           *
  ****************************************************************
  Database Metadata store procedure, SYSIBM.SQLPRIMARYKEYS, is
  used when a CLI application calls SQLPrimarykeys(). When INI
  configuration keyword DBNAME is in use and DATATYPE='OLEDB' is
  set, CLI driver receives SQLCODE -203 on the call to procedure
  SYSIBM.SQLPRIMARYKEYS.
  

Problem conclusion

• The reported problem is fixed. The correct result set is
  returned and no SQLCODE203 is issued.
  

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:

  UI19383 UI19384

Modules/Macros

•    DSN@PRKU DSNAPRKU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI19383

     UP14/07/23 P F407

• RB10 PSY UI19384

     UP14/07/23 P F407

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.