PH30883: PARSER ERROR WITH COLUMN NAME "CHECK" UNEXPECTED TOKEN AFTER XXXXXX KEYWORD EXPECTED KEYWORD DISTINCT-NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a table column is named CHECK, the
  parser expects this keyword to be used in a different context,
  and may issue the following error (for example):
  
  Unexpected token after CHAR keyword - expected keyword
  distinct-name
  
  ADB2PA: The following statement could not be parsed :
  (DDL follows)
  
  This may occur, for example, when reading DDL, using Change
  Management to import table DDL, or when Object Compare tries to
  create a version file.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Change Management function and users    *
  *                 of Db2 Object Comparison Tool for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Importing a change where a table column *
  *                      is named CHECK might result in a parser *
  *                      error.                                  *
  ****************************************************************
  When the DDL reader encounters a table column named CHECK, the
  parser might confuse it with the start of a check constraint.
  
  This situation can occur when importing a change or when
  comparing DDL by using Object Compare.
  
  Example error message:
  Unexpected token after INTEGER keyword - expected keyword
  distinct-name
  The DDL reader could not parse a DDL statement.
  ADBCDTS - Unsuccessful completion
  
  In this example, the column name is CHECK INTEGER.
  

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:

  UI73699

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73699

     UP21/02/02 P F102

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.