PK51325: OBJECT COMPARE GETS PARSING WHEN CREATE TABLE HAS A SEMICOLON IN A STRING CONSTANT OR COMMENT RC20 ADBC033E UNSUCCESSFUL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When importing changes r720 of a table with a  string constant
  or comment contains a semicolon the user gets:
  Error occured when parsing the following stmt :
  
  CREATE TABLE S100447.EMPPROJACT (EMPNO CHAR(6) FOR SBCS DATA NOT
  NULL, PROJNO CHAR(6) FOR SBCS DATA NOT NULL WITH DEFAULT ';',
  ACTNO SMALLINT NOT NULL, EMPTIME DECIMAL(5, 2) WITH DEFAULT
  NULL, EMSTDATE DATE WITH DEFAULT NULL, EMENDATE DATE WITH
  DEFAULT NULL) IN DSN8D71L.DSN8S71P AUDIT NONE DATA CAPTURE NONE
  CCSID EBCDIC NOT VOLATILE COMMIT
  
  Token number = 00073, Token =COMMIT
  Register error. rc=            20
  ADBC033EUnsuccessful parse of DDL statement.  Change Sequence =
  3
  .
  Additional symptoms: msgADBC033E
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: When user  imports changes  on R720 for a    *
  *                 table that contains a semicolon in string    *
  *                 constant or comment.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object compare V7.2  when the comparing *
  *                      source catalog table (having  semicolon *
  *                      in string constant) with target catalog *
  *                      table  (not  having the string constant *
  *                      semicolon) fails  n step T04REG, during *
  *                      register  change  resulting in  parsing *
  *                      error RC 20.                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Parsing error occurred during token COMMIT, because the import
  changes inserts COMMIT in change statements ADBCHGS. The error
  is not due to table having semicolon in string constant.
  

Problem conclusion

• The problem is been fixed only in 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

•    ADB2CID
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK30223

     UP07/10/25 P F710

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.