PM26512: WSLVAL STEP ENDS FUNCTION = ADB2WVL,LINE 350: SIGNAL ERROR RC=08SQLCODEN010 AND SQLCODEN104 COMMENT ON TABLE WITH SEMICOLON.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• WSLVAL STEP ENDS FUNCTION = ADB2WVL,LINE 350: SIGNAL ERROR RC=08
  SQLCODEN010 AND SQLCODEN104 COMMENT ON TABLE WITH SEMICOLON.
  SQL error in PREPARE for statement:
         CREATE PERM = 0
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "=". SOME
  SYMBOLS THAT MIGHT BE
           LEGAL ARE: TABLESPACE
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 and DB2 Object Comparison Tool for           *
  *                 z/OS who generate WSL for the                *
  *                 COMMENT ON TABLE statement that              *
  *                 has an embedded semicolon.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the COMMENT ON TABLE               *
  *                      statement has an embedded               *
  *                      semicolon, the generated WSL            *
  *                      may generate a syntax error             *
  *                      which causes the validate WSL           *
  *                      to fail with SQLCODEN10 and             *
  *                      SQLCODEN104.                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Validate WSL SQLCODEN10 and SQLCODEN104
  errors are observed due to an embedded semicolon
  in the COMMENT ON TABLE syntax.
  

Problem conclusion

• The part has been modified to parse the statement
  correctly and generate correct statement in WSL.
  

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

•    ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 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.