PH45611: PARSER FAILURE WHEN PROCESSING TRIM FORMAT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PARSER fails with "unexpected token" error when processing a
  TRIM format which is different from the one specified in the Db2
  SQL documentation even though the different format is
  successfully executable by Db2.
  
  ADDITIONAL SYMPTOMS:
  MSGADB2PA
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DDL parser fails when processing    *
  *                      a view that uses the TRIM function.     *
  ****************************************************************
  Parsing DDL that uses the TRIM function in a view with the
  following formats fails:
  TRIM(string_expression, {B,BOTH,T,TRAILING,L,LEADING},
  trim_constant)
  
  TRIM(string_expression, {B,BOTH,T,TRAILING,L,LEADING})
  
  The following error is returned:
  
  ADB7715E The DDL reader could not parse a DDL
  statement.
     The return code: 16
     The error statement: >view_ddl<
  
  Unexpected token after DSN_EINGANG keyword - expected
  keyword ")"
  
  ADB2PA: The following statement could not be parsed :
  
  >view_ddl<
  
  Token number =     41, Token = ,
  
  Note: Keywords and token numbers might vary depending on the
  view definition.
  

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:

  UI81693 UI81700

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81693

     UP22/08/02 P F208

• RD10 PSY UI81700

     UP22/08/02 P F208

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.