PI59114: DB2 ADMIN TOOL DDL LINE COMMAND - ADB2PA5.TOKENIZE SYNTAX ERROR DURING STATEMENT SCAN. TEXT=^= 0)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Admin Tool, line command DDL or GEN, receive the
  following error on when using caret symbol in SQL:
  
  ADB2PA5.TOKENIZE
  O i=0004856 st=00 Char=¢ 4A Sym#=01 N st=00 Act=77 Typ=10
    Ts=0004845 P=0004856 C=0000000
  i=000004856L(sql_stmt)=000007992L(sql_stmt_caps)=000007945
  Syntax error during statement scan. Text=^= 0)
  
  ADB2PA5: The following statement could not be parsed
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use DDL or GEN to               *
  *                 generate a view which contains the           *
  *                 hex 'B07E'X as not equal sign when           *
  *                 sccsid=500 in DSNHDECP.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using DDL or GEN to generate       *
  *                      a view which contains the hex 'B07E'X   *
  *                      as the not equal sign when sccsid=500   *
  *                      in DSNHDECP, the following error is     *
  *                      observed:                               *
  *                                                              *
  *                        Syntax error during statement scan.   *
  *                        ADB2PA5: The following statement      *
  *                                 could not be parsed          *
  ****************************************************************
  * RECOMMENDATION: Apply the recommended service.               *
  ****************************************************************
  When using DDL or GEN to generate a view which contains the
  hex 'B07E'X as the not equal sign when sccsid=500 in DSNHDECP,
  the following error is observed:
  
  ADB2PA5.TOKENIZE
  O i=0004856 st=00 Char=¢ 4A Sym#=01 N st=00 Act=77
  Typ=10 Ts=0004845 P=0004856 C=0000000
  i=000004856L(sql_stmt)=000007992L(sql_stmt_caps)=000007945
  Syntax error during statement scan. Text= = 0..
  
  ADB2PA5: The following statement could not be parsed..
  

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:

  UI38412 UI38413 UI38414

Modules/Macros

•    ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI38412

     UP16/06/09 P F606

• RB10 PSY UI38413

     UP16/06/09 P F606

• RB20 PSY UI38414

     UP16/06/09 P F606

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.