PI06256: WSLVAL SQLCODEN104 CAUSED BY INVALID ALTER TABLE VALIDPROC SYNTA X IN WSL ( MISSING PROC NAME ).

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS' WSL validation step
  fails with a SQLCODEN104 / SQLCODE -104:
    DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL " ". SOME
  SYMBOLS THAT
             MIGHT BE LEGAL ARE: <IDENTIFIER> NULL
    DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
    DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD    = 3  0  0  -1  40  502 SQL DIAGNOSTIC
  as the WSL contains invalid DDL:
  
  ALTER TABLE >schema<.>table< VALIDPROC   ;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who compare tables and         *
  *                 use IGNORE field VALPROC.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
  *                      for z/OS Work Statement List            *
  *                      (WSL) Validation step fails with        *
  *                      a SQLCODEN104 /                         *
  *                      SQLCODE=-104:                           *
  *                                                              *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL                  *
  *                      " ". SOME SYMBOLS THAT                  *
  *                           MIGHT BE LEGAL ARE:                *
  *                      >IDENTIFIER< NULL                       *
  *                                                              *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      as the WSL contains invalid DDL:        *
  *                                                              *
  *                      ALTER TABLE >schema<.>table<            *
  *                      VALIDPROC                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Compare program generates invalid statement 'ALTER
  TABLE >schema<.>table< VALIDPROC   ;'.
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

• ž**** PE14/02/06 FIX IN ERROR. SEE APAR PI11201  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI14593 UI14594

Modules/Macros

•    ADBCCMM  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI14593

     UP14/01/30 P F401

• RA20 PSY UI14594

     UP14/01/30 P F401

• RB10 PSY UI14595

     UP14/01/30 P F401

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.