PK50436: GOC ALTER OF PRIMARY KEY IS MISSING SEMI COLON SO WHEN APPLY OF JCL OR RUN WSL GET SQLCODEN199 SQLCODE199N SQLCODE199

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using Object Compare OC to alter a primary key results in
  missing end ; semi colon . When either WSL or JCL are run then
  get sqlcoden199 sqlcode199n sql code -199:
  ADD PRIMARY KEY
  
  (CO_TYPBP_004JCMD,CO_DEST_004JCMD,DA_CMDF_004JCMD,NR_ESTAF_1,
  
  NR_ROUND_ESTAF_2,NR_ROUND_ESTAF_3,NR_ID_UNSALE,NR_WKPOST_004JCMD
  )
     SET CURRENT SQLID = 'LUCYK' ;
  sqlerror on ALTER      command, PREPARE    function
   DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD
  CURRENT.  TOKEN SUMMARY
       MATERIALIZED WAS EXPECTED
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 506  0  0  -1  176  0 SQL DIAGNOSTIC
                        INFORMATION
  DSNT416I SQLERRD    = X'000001FA'  X'00000000'  X'00000000'
  

Local fix

• Please apply ptf when it becomes available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare V7.1 and V7.2.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Currently, an ALTER ADD PRIMARY KEY     *
  *                      statement can be truncated depending    *
  *                      on the number of columns and the        *
  *                      length of the column names in the       *
  *                      PRIMARY KEY definition.                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Object Compare was changed so the ALTER ADD PRIMARY KEY was not
  truncated.
  

Problem conclusion

• The problem has been fixed in Object Compare V7.1 and V7.2.
  

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

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK35296

     UP08/04/16 P F804

• R720 PSY UK35297

     UP08/04/16 P F804

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.