PM67266: ADB21 'AND/OR OTHER SELECTION CRITERIA (OPTION XC SHOWS YOU COLUMNS FOR OPTION X)' VALUE FIELD QUOTES RESULTS IN SQLCODEN180

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Administration Tool for z/OS panel ADB21 'And/or other
  selection criteria (option xC shows you columns for option x)''s
  'Value' field adds quotes to the entered string which can result
  in a SQLCODE -180 / SQLCODEN180 if the Value field contains
  a criteria such as CURRENT TIMESTAMP - 1 HOUR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who specify a value containing the      *
  *                 DB2 datetime special register                *
  *                 (CURRENT TIMESTAMP / CURRENT_TIMESTAMP)      *
  *                 for the sub-field 'Value' of 'And/or other   *
  *                 selection criteria (option xC shows you      *
  *                 columns for option x)' field on panel        *
  *                 ADB21 'System Catalog.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when specifying a value containing      *
  *                      the DB2 datetime special register       *
  *                      (CURRENT TIMESTAMP/CURRENT_TIMESTAMP)   *
  *                      for the sub-field 'Value' of 'And/or    *
  *                      other selection criteria (option xC     *
  *                      shows you columns for option x)'        *
  *                      field on panel ADB21, DB2 Admin Tool    *
  *                      does not display objects in the DB2     *
  *                      catalog according to the selection      *
  *                      criteria and fails with a               *
  *                      SQLCODEN180 / SQLCODE = -180:           *
  *                                                              *
  *                      DSNT408I SQLCODE = -180,                *
  *                      ERROR:  THE DATE, TIME,                 *
  *                      OR TIMESTAMP VALUE CURRENT              *
  *                      TIMESTAMP value IS INVALID              *
  *                      DSNT418I SQLSTATE   = 22007             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When specifying a value containing the DB2 datetime special
  register (CURRENT TIMESTAMP / CURRENT_TIMESTAMP) for the
  sub-field 'Value' of 'And/or other selection criteria
  (option xC shows you columns for option x)' field on panel
  ADB21, DB2 Administration Tool does not display objects
  in the DB2 catalog because quotes are wrongly added to
  the specified value when building the selection criteria
  and fails with a SQLCODEN180 / SQLCODE=-180,
  

Problem conclusion

Temporary fix

Comments

• Problem has been resolved.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK82936 UK82937

Modules/Macros

•    ADBCHKSP ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82936

     UP12/10/30 P F210

• RA20 PSY UK82937

     UP12/10/30 P F210

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.