PH21447: DDL GEN FUNCTION UDF DECLARE CHAR INTEGER UNEXPECTED TOKEN;VALIDATE BIND 'VALID' 'N' ADB1664E INTERNAL ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL or GEN of a user-definedfunction (UDF) may fail with one of
  the following errors:
  
  1)  A parser error occurs when the UDF contains a DECLARE
  CHAR statement with an integer constant default value.
  
  Error message:
  Unexpected token after DEFAULT keyword - expected keyword
  '00000' or string-constant.
  
  2) If the UDF is defined with VALIDATE BIND, and the
  associated package is invalid (SYSPACKAGE has value 'N'
  for column 'VALID'), GEN may result in the following error
  messages:
  
  ADB1664E An internal error occurred. Diagnostic
  text=ADB2REH.ALTER_RT_VALIDATE_BIND(7166):INTERR00000003RT.
               Reason code = 4
  
  ADB1646E An error has occurred while generating DDL for an
  object.
  
  
  Keywords:  msgadb1664e;msgadb1646e
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: Reverse Engineering program (GEN)       *
  *                      fails with parser or internal error.    *
  ****************************************************************
  When a user tries to generate DDL for a user-defined function
  (UDF) by using the GEN program, the process fails under one or
  both of the following conditions:
  
  1. A parser error occurs when the UDF contains a DECLARE
  CHAR statement with an integer constant default value.
  
  Error message:
  Unexpected token after DEFAULT keyword - expected keyword
  '00000' or string-constant.
  
  2. GEN errors ADB1664E and ADB1646E occur when the UDF is
  defined with VALIDATE BIND and the associated package is
  invalidated (VALID = N).
  

Problem conclusion

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

  UI69456

Modules/Macros

• ADB2PA   ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69456

     UP20/06/01 P F005

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.