PM65132: PANEL ADB21 APPENDS % WILDCARD EVEN THOUGH LIKE OFF REQUESTED SQLCODEN104 WHEN OTHER CRITERIA VALUE CONTAINS QUOTED STRING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS report unexpected
  results:
  1. When LIKE OFF option has been set a % wildcard character is
     appended to OTHER SELECTION CRITERIA VALUE parm when
     Operator ===> LIKE is specified.
     For example, panel input like:
  .
  And/or other selection criteria ...
  Column   ===> CREATOR > Operator ===> LIKE  Value ===> SYS_BM
  .
  Produces SELECT with % appended to VALUE parm, like:
  .
  SELECT T.* FROM SYSIBM.SYSDATABASE T  WHERE  T.CREATOR
         LIKE 'SYS_BM%' FOR FETCH ONLY
  .
  2. When VALUE parm contains quoted string, SQLCODEN104 occurs:
     For example, panel input like:
  .
  And/or other selection criteria ...
  Column   ===> CREATOR > Operator ===> LIKE  Value ===> 'SYS_BM'
  .
  Generates incorrect SELECT statement syntax, like:
  .
  SELECT T.* FROM SYSIBM.SYSDATABASE T  WHERE  T.CREATOR
         LIKE 'SYS_BM'% FOR FETCH ONLY
  .
  causing SQLCODEN104 error, like:
  .
  ADB2E1 in --------------------- DB2 Error Display 1 ...
  Rollback done
     SQLCODE : -104                           DSNTIAR CODE :  0
  .
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "%". SOME
           SYMBOLS THAT MIGHT BE LEGAL ARE: || CONCAT AND ESCAPE
           HAVING GROUP ORDER INTERSECT EXCEPT UNION
  

Local fix

• Use PROMPT SEL ON and EDIT generated SELECT statement as needed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'And/or other selection     *
  *                 criteria (option xC shows you columns for    *
  *                 option x)' OPERATOR parameter with           *
  *                 value 'LIKE' on panel ADB21 'System          *
  *                 Catalog', and/or use a quoted string for     *
  *                 the VALUE parameter.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users report the following:             *
  *                                                              *
  *                      1.  When the LIKE OFF option is used,   *
  *                          a '%' wildcard character is         *
  *                          appended to the OTHER SELECTION     *
  *                          CRITERIA VALUE parameter when       *
  *                          'Operator ===> LIKE' is specified   *
  *                          on panel ADB21 'System Catalog'.    *
  *                          For example, panel input like:      *
  *                                                              *
  *                      And/or other selection criteria         *
  *                      (option xC shows you columns for        *
  *                      option x):                              *
  *                                                              *
  *                      Column   ===> CREATOR                   *
  *                      Operator ===> LIKE                      *
  *                      Value ===> SYS_BM                       *
  *                                                              *
  *                      Produces a SELECT statement with        *
  *                      the '%' wildcard character appended     *
  *                      to the VALUE parameter, like:           *
  *                                                              *
  *                      SELECT T.* FROM                         *
  *                      SYSIBM.SYSDATABASE T                    *
  *                      WHERE  T.CREATOR                        *
  *                             LIKE 'SYS_BM%' FOR               *
  *                      FETCH ONLY                              *
  *                                                              *
  *                      2. When the VALUE parameter             *
  *                         contains a quoted string, an         *
  *                         SQLCODE=-104 / SQLCODEN104           *
  *                         occurs:                              *
  *                                                              *
  *                      For example, panel input like:          *
  *                                                              *
  *                      And/or other selection criteria         *
  *                      (option xC shows you columns for        *
  *                      option x):                              *
  *                                                              *
  *                      Column   ===> CREATOR                   *
  *                      Operator ===> LIKE                      *
  *                      Value ===> 'SYS_BM'                     *
  *                                                              *
  *                      Generates an incorrect SELECT           *
  *                      statement:                              *
  *                      .                                       *
  *                      SELECT T.* FROM                         *
  *                      SYSIBM.SYSDATABASE T                    *
  *                      WHERE  T.CREATOR                        *
  *                             LIKE 'SYS_BM'% FOR               *
  *                      FETCH ONLY                              *
  *                                                              *
  *                      causing the following error:            *
  *                                                              *
  *                      SQLCODE : -104                          *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL "%".             *
  *                      SOME SYMBOLS THAT MIGHT                 *
  *                      BE LEGAL ARE: || CONCAT AND             *
  *                      ESCAPE HAVING GROUP ORDER               *
  *                      INTERSECT EXCEPT UNION                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users report the following:
  
  1.  When the LIKE OFF option is used, a '%' wildcard character
      is appended to the OTHER SELECTION CRITERIA VALUE
      parameter when 'Operator ===> LIKE' is specified on panel
      ADB21 'System Catalog'.  For example, panel input like:
  
  And/or other selection criteria (option xC shows you columns for
  option x):
  
  Column   ===> CREATOR
  Operator ===> LIKE
  Value ===> SYS_BM
  
  Produces a SELECT statement with the '%' wildcard character
  appended to the VALUE parameter, like:
  .
  SELECT T.* FROM SYSIBM.SYSDATABASE T
  WHERE  T.CREATOR LIKE 'SYS_BM%' FOR
  FETCH ONLY
  .
  2. When the VALUE parameter contains a quoted string, an
  SQLCODE=-104 / SQLCODEN104 occurs:
  
  For example, panel input like:
  
  And/or other selection criteria (option xC shows you columns for
  option x) :
  
  Column   ===> CREATOR
  Operator ===> LIKE
  Value ===> 'SYS_BM'
  
  Generates an incorrect SELECT statement:
  .
  SELECT T.* FROM SYSIBM.SYSDATABASE T
  WHERE  T.CREATOR LIKE 'SYS_BM'% FOR
  FETCH ONLY
  
  causing the following error:
  
  SQLCODE : -104
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "%".
  SOME SYMBOLS THAT MIGHT BE LEGAL ARE: || CONCAT AND
  ESCAPE HAVING GROUP ORDER INTERSECT EXCEPT UNION
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK79469

Modules/Macros

•    ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK79469

     UP12/06/13 P F206

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.