PH38535: GEN: MISSING COMMENTS IN SQL FUNCTIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN may not generate some comments outside of the SQL body of a
  function, even if they are stored in the TEXT column of
  SYSIBM.SYSROUTINES.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Comments are missing in the generated   *
  *                      DDL for SQL functions.                  *
  ****************************************************************
  Comments that are outside of the SQL body of an SQL function
  might not be generated even if they are stored in the
  SYSIBM.SYSROUTINES catalog table.
  
  Example:
  --#SET SQLFORMAT SQLPL
    CREATE FUNCTION TS5791.NUMSEQTABLE7
      --after udf name
      -- before maxno
      (MAXNO INTEGER)
      -- before returns
      RETURNS TABLE(SEQNO INTEGER)
      -- before external
      EXTERNAL ACTION
      --before reads
      READS SQL DATA
      --before called
      CALLED ON NULL INPUT
      -- before parameter
      PARAMETER CCSID EBCDIC
      --before inherit
      INHERIT SPECIAL REGISTERS
      --before secure
      NOT SECURED
      -- before lang sql
      LANGUAGE SQL
      -- before specific
      SPECIFIC NUMSEQTABLE7
      -- before not deterministic
      NOT DETERMINISTIC
      -- before return
      RETURN
      -- sql body comment
      -- 'single quote com'
      -- "double quote com"
      WITH NUMSEQ(ROWNO) AS(SELECT  1 FROM "SYSIBM".SYSDUMMY1
  UNION ALL
      SELECT  ROWNO + 1 FROM NUMSEQ
        WHERE ROWNO < MAXNO
      ) SELECT * FROM NUMSEQ`
  --#SET TERMINATOR ;
  
  In the above example, regarding comments, only the following
  are generated:
  
  -- sql body comment
  -- 'single quote com'
  -- "double quote com"
  

Problem conclusion

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

  UI77890

Modules/Macros

• ADB2REG  ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI77890

     UP21/11/03 P F111

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.