PH32638: GEN/DDL DOES NOT DISPLAY COMMENTS FOR TRIGGERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR supports the display of comments
  in GEN/DDL output of triggers.
  

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       *
  *                      triggers even when those comments are   *
  *                      stored in the STATEMENT column of the   *
  *                      SYSTRIGGERS catalog table.              *
  ****************************************************************
  This APAR addresses 3 issues related to GEN and triggers which
  contain comments:
  
  1. GEN should support comments in triggers when "Include SQL
     comments" is set to YES, and the trigger was created so that
     the comments are stored in SYSTRIGGERS. Example:
  
  --#SET TERMINATOR `
  --#SET SQLFORMAT SQLPL
    CREATE TRIGGER USER01.EMPTY_UTLIST
      AFTER DELETE ON USER01.ADBCHG
      //* COMMENT BLOCK 01
          DISABLE DEBUG MODE
      SQL PATH SESSION_USER, SYSTEM PATH
      BEGIN ATOMIC
      //*COMMENT BLOCK 02
      --SIMPLE COMMENT
      DELETE FROM USER01.UTLIST ;
      //* MULTI
      //*   LINE
      //*   COMMENT
      END `
  --#SET TERMINATOR ;
  
  2. The --#SET SQLFORMAT SQLPL statement should be generated for
     triggers when "Include SQL comments" is set to YES.
  
  3. In some cases, the SQLCMTS parameter was not generated
     in the GEN JCL when "Include SQL comments" is set to YES.
  

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:

  UI74746

Modules/Macros

• ADB2GEN2 ADB2GENB ADB2REG  ADB2REH  ADBHGEN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74746

     UP21/04/06 P F104

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.