PI80830: DB2 ADMIN TOOL - USING X'BBBB' CONCATENATION CHARACTERS GETS ADB2PA: THE FOLLOWING STATEMENT COULD NOT BE PARSED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using X'BBBB' concatenation characters gets parse problem:
  Unexpected token after 01 keyword - expected keyword
               <right-square-bracket>
  
  ADB2PA: The following statement could not be parsed :
  

Local fix

• Use CONCAT keyword in place of x'BBBB'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration for z/OS     *
  *                 who uses CCSID 500.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SQL parser does not handle          *
  *                      the special characters for              *
  *                      left square bracket, right square       *
  *                      bracket, and concat correctly           *
  *                      (code points x'4a',x'5a', and x'bb')    *
  *                      when using CCSID 500. The parser        *
  *                      fails with messages like:               *
  *                                                              *
  *                      Unexpected token after 01 keyword -     *
  *                      expected keyword >right-square-bracket< *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using CCSID 500 and parsing an object e.g. by
  running GEN on an SQL procedure, some special
  character are not handled correctly and causing
  the SQL parser to fail.
  

Problem conclusion

• The problem has been solved.
  

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:

Modules/Macros

•    ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI50554

     UP17/09/26 P F709

• RC10 PSY UI50555

     UP17/09/26 P F709

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.