PH25944: SUPPORT COMMENTS SQL FUNCTIONS NATIVE STORED PROCEDURES GEN TSO DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR adds and expands support for GEN AND DDL to generate
  comments in native stored procedures and SQL functions.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN does not produce comments for SQL   *
  *                      functions even when those comments are  *
  *                      stored in the TEXT column of the        *
  *                      SYSROUTINES catalog table.              *
  *                                                              *
  *                      Also, other aspects of comment          *
  *                      generation can be improved.             *
  ****************************************************************
  1. GEN should support comments in the SQL body of SQL functions.
  
     Examples:
  
       a. Inside the RETURN of an inline SQL scalar function:
          RETURN //Calculate Tangent//
          SIN(X) / COS(X)
       b. Inside the RETURN of an SQL table function:
          RETURN //GET COL1//
          SELECT  COL1 FROM
          //FROM THIS TABLE // SCHEMA.TB1
       c. Inside the body of a non-inline SQL scalar function:
          BEGIN
          // set the sql code//
          SET RCODE = 'SQLCODE' ;
          RETURN RCODE ;    --return it
          END
  
  2. The --#SET SQLFORMAT SQLPL statement should be generated for
     native stored procedures and SQL functions to ensure that
     comments are stored in SYSROUTINES.TEXT when "Include SQL
     comments" is set to YES.
  
  3. The GEN option "Include SQL comments" currently applies only
     to batch. This restriction should be removed and the option
     extended to support TSO execution for applicable objects.
  
  4. The "Include SQL comments" value should be used for the DDL
     line command. This change would allow the user to control
     whether comments are generated.
  
  5. Some combinations of simple comments (--comment) and SQL
     stored procedures may result in a parser error.
  

Problem conclusion

• The problems have 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:

  UI71456

Modules/Macros

• ADB2A2WS ADB2GEN  ADB2GEN2 ADB2GEN6 ADB2GENS ADB2GENX ADB2REG
  ADB2REH  ADBHGEN  ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71456

     UP20/09/11 P F009

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.