PI98405: INVALID DDL GENERATED FOR STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Generated DDL can have extra spaces in the simple comment
  character with two consecutive hyphens (--) for CREATE
  PROCEDURE, which leads to the following error:
  SQLCODE = -104, ERROR: ILLEGAL SYMBOL "-". SOME SYMBOLS
  THAT MIGHT BE LEGAL ARE: ALTER CREATE INSERT UPDATE DELETE
  OP CLOSE FETCH PREPARE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Generated DDL can have extra spaces in  *
  *                      the simple comment character with two   *
  *                      consecutive hyphens (--) for CREATE     *
  *                      PROCEDURE, which leads to the           *
  *                      following error:                        *
  *                      SQLCODE = -104, ERROR: ILLEGAL SYMBOL   *
  *                      "-". SOME SYMBOLS THAT MIGHT BE LEGAL   *
  *                      ARE: ALTER CREATE INSERT UPDATE DELETE  *
  *                      OP CLOSE FETCH PREPARE                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  010PC2Ÿ UI57180

Modules/Macros

•    CKZCALNC CKZCAL9C CKZCAQNC CKZCAQ1C CKZCATM
  CKZCATMO CKZCAT01 CKZCCTNC CKZCCT9C CKZCDB9C CKZCDPNC CKZCDTNC
  CKZCDT0C CKZCDT1C CKZCDT9C CKZCFNNC CKZCFN0C CKZCFN9C CKZCHECK
  CKZCIXNC CKZCIX0C CKZCIX2C CKZCIX9C CKZCMTNC CKZCMT0C CKZCPKNC
  CKZCPK0C CKZCPK1C CKZCPK9C CKZCPLNC CKZCPL0C CKZCPL1C CKZCPL9C
  CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C CKZCSNNC CKZCSN9C
  CKZCSPNC CKZCSP9C CKZCSQNC CKZCSQ1C CKZCSQ9C CKZCTBNC CKZCTB0C
  CKZCTB1C CKZCTB2C CKZCTB9C CKZCTRNC CKZCTR0C CKZCTR9C CKZCTSNC
  CKZCTS0C CKZCTS2C CKZCTS9C CKZCVANC CKZCVA1C CKZCVTNC CKZCVT0C
  CKZCVT9C CKZCXANC CKZCXT9C CKZDOCID CKZFATTR CKZFBASE CKZFCD02
  CKZ2PJCI CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM CKZ2PRFL CKZ2PRIM
  CKZ2PZPI CKZ2RTSC CKZ2SASV CKZ2SBCI CKZ2SFRJ CKZ2SFSJ CKZ2SFTJ
  CKZ2SIDL CKZ2SJCI CKZ2SJCL CKZ2SJTS CKZ2SJTV CKZ2SKL  CKZ2SOMT
  CKZ2SOPR CKZ2SPCC CKZ2SPRF CKZ2SRSV CKZ2SSCP CKZ2SSDS CKZ2SSLB
  CKZ2SSMC CKZ2SSSJ CKZ2SSTM CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV
  CKZ2STSS CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP CKZ2TJCL CKZ2TSCI
  CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL CKZ2USET CKZ49    CKZ6ADLL
  CKZ6IGNR CKZ6MAIN CKZ6SPDD CKZ6TPDD CKZ6TPRM HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI57180

     UP18/07/13 P F807

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.