PI39672: AN EMPTY RESULTSET IS RETURNED FROM JDBC GETPRIMARYKEYS() IF NULL SCHEMA PARM PASSED IN AND TABLE NAME CONTAINS '_'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AN EMPTY RESULTSET MAY BE RETURNED FROM SQLPRIMARYKEYS IF THE
  TABLE OR SCHEMA PARM PASSED IN IS NULL
  

Local fix

• Change the invocation of sqlprimarykeys to include a schema and
  table name instead of null values
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users of IBM Data Server Driver for      *
  *                 JDBC and SQLJ that connect to DB2 10 for     *
  *                 z/OS or DB2 11 for z/OS                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: An empty result set is returned from    *
  *                      JDBC getPrimaryKeys() if the input      *
  *                      schema name is NULL and the input       *
  *                      table name contains UNDERSCORE          *
  *                      character '_'.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Database Metadata store procedure, SYSIBM.SQLPRIMARYKEYS, is
  invoked when a JDBC application calls getPrimaryKeys().
  When getPrimaryKeys()'s input schema name is NULL and its
  input table name contains UNDERSCORE('_') character, Procedure
  SQLPRIMARYKEYS() adds an ESCAPE character before each
  UNDERSCORE character. DB2 doesn't find the searched table
  object, an empty result set is returned.
  

Problem conclusion

• Extra ESCAPE character is removed before sending the table
  object to DB2, the correct result set is returned.
  

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:

  UI28175 UI28176

Modules/Macros

• DSN@PRKU DSNAPRKU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI28175

     UP15/06/19 P F506

• RB10 PSY UI28176

     UP15/06/19 P F506

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.