PI88289: GOC - INCOMPLETE DDL FOR NON NATIVE SQL STORED PROCEDURES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incomplete DDL for non Native SQL Stored Procedures.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use GEN/DDL function       *
  *                 on external SQL procedures which             *
  *                 contain a SQL-routine-body element.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When processing external SQL            *
  *                      procedures which contain a              *
  *                      SQL-routine-body ( typically            *
  *                      created through a call to               *
  *                      SYSPROC.DSNTPSMP ), the                 *
  *                      GEN/DDL function displays               *
  *                      incomplete DDL and does                 *
  *                      not generate the SQL-routine-body.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When processing external SQL procedures which contain
  a SQL-routine-body ( typically created through a call to
  SYSPROC.DSNTPSMP ), the GEN/DDL function
  displays incomplete DDL and does not generate the
  SQL-routine-body.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI51252 UI51253

Modules/Macros

•    GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB20 PSY UI51252

     UP17/10/23 P F710

• RC10 PSY UI51253

     UP17/10/23 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.