PM19699: WSLVAL STEP ENDS FUNCTION = ADB2WVL, LINE 350: SIGNAL ERROR RC=0 8 SQLCODEN010 AND SQLCODEN104 COMMENT ON TABLE WITH SEMICOLON

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• and:
  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 the DB2 Object Comparison Tool           *
  *                 for z/OS who generate WSL for the            *
  *                 COMMENT ON TABLE statement,                  *
  *                 which has an embedded semicolon.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the COMMENT ON TABLE               *
  *                      statement has an embedded               *
  *                      semicolon, the generated WSL            *
  *                      may have 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 the correct statement in WSL.
  See APAR PM26512 for the DB2 Object Comparison
  Tool for z/OS Version 10 solution.
  

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:

  UK63548

Modules/Macros

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK63548

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