PM20848: PROG755 / IKT00405I SCREEN ERASURE WHEN ISSUING THE DDL COMMAND AGAINST A STORED PROCEDURE / ADB1847E WARNING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADB1870I DDL header requested but suppressed because parm
  DDL_comments Reason code = 20
           Processing Stored Procedure C717086.CMTEST version
  ADB1847E WARNING : Error parsing DDL NSP statement. Please
  verify the generated DDL  Reason code = 28
  
  and the output dataset will show only the --#SET TERMINATOR
  statements.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN or DDL command to       *
  *                 generate DDL for a Native SQL Procedure      *
  *                 (NSP) that has a version ID that contains    *
  *                 a character that is not alphanumeric         *
  *                 (a-z,0-9), an underscore (_), or a           *
  *                 national language character ( $, #, @ ).     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool's DDL line  *
  *                      command on panel ADB21O "Stored         *
  *                      Procedures" tries to generate DDL for   *
  *                      NSP, which has the version ID that      *
  *                      contains a dot, the following message   *
  *                      was shown:                              *
  *                                                              *
  *                      ADB1847E WARNING :                      *
  *                      Error parsing DDL NSP statement.        *
  *                      Please verify the generated DDL         *
  *                      Reason code = 28 and the output         *
  *                      dataset will show only the              *
  *                      --#SET TERMINATOR statements.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The version ID for a native SQL procedure was not quoted which
  could result in a parser error when the NSP is generated.
  

Problem conclusion

• Program has been modified to add quotes around the version ID
  of a native SQL procedure when needed.
  

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:

  UK67518 UK67519

Modules/Macros

•    ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67518

     UP11/05/11 P F105

• R720 PSY UK67519

     UP11/05/11 P F105

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.