PH37528: DB2 ADMIN TOOL: GEN ADB2PA PARSER ERROR ON STRING UNIT SPECIFICATIONS: CODEUNITS32, CODEUNITS16, OCTETS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin tool: Gen may report a parser error on string unit
  specifications: CODEUNITS32, CODEUNITS16, OCTETS
  
  For example:
  
  
  Unexpected token after CHAR(... - expected right paren
  
  ADB2PA: The following statement could not be parsed :
  
  CREATE TRIGGER trig1 AFTER INSERT
  ON a.t1
  REFERENCING NEW AS NEWROW FOR EACH ROW MODE DB2SQL
  
  etc.  followed by
  
  Token number =    159, Token = CODEUNITS16
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN fails with a parser error on        *
  *                      string unit specifications.             *
  ****************************************************************
  When processing built-in string types, such as CHAR, and a
  string unit specification, such as CODEUNITS16, CODEUNITS32,
  or OCTETS, GEN might fail with a parser error.
  
  Example error:
  
  Unexpected token after CHAR(... - expected right paren
  
  ADB2PA: The following statement could not be parsed
  
  (and after hitting enter:)
  
  Token number = nnn, Token = CODEUNITS16
  

Problem conclusion

• The 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:

  UI76933

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76933

     UP21/08/28 P F108

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.