PQ84131: OBJECT COMPARE FAILS WHEN PARSING COLUMN WITH NAME OF PRIMARY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare encountered an error while parsing the column
  name PRIMARY .
  Invalid token after PRIMARY keyword - expected KEY keyword
  
  Error occured when parsing the following stmt :
  
  CREATE TABLE TB05001X (PRIMARY CHAR(1) FOR SBCS DATA NOT NU
  Token number = 0006, Token =CHAR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who parse the        *
  *                 column name PRIMARY are affected.            *
  *                 Note: this problem was reported from         *
  *                 DB2 Object Comparison Tool                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An error was encountered while parsing  *
  *                      the column name PRIMARY :               *
  *                      Invalid token after PRIMARY keyword -   *
  *                      expected KEY keyword                    *
  *                      Note: for example,                      *
  *                      Error occured when parsing the          *
  *                      following stmt :                        *
  *                      CREATE TABLE TB05001X (PRIMARY CHAR(1)  *
  *                      FOR SBCS DATA NOT NU                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The reported problems are fixed in ADB2PA modules in
  both 410 and 420 releases of DB2 ADMIN TOOL.
  

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:

Modules/Macros

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ86163

     UP04/03/25 P F403

• R420 PSY UQ86164

     UP04/03/25 P F403

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.