PM75036: GEN CREATES TIMESTAMP(0) VS TIMESTAMP OR TIMESTAMP(6) IN DDL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN / DDL function
  created DDL with TIMESTAMP(0) rather than TIMESTAMP or
  TIMESTAMP(6) data-type.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN / DDL function          *
  *                 against an external SQL stored procedure     *
  *                 on DB2 10 New Function mode.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN / DDL function created DDL with     *
  *                      TIMESTAMP(0) rather than TIMESTAMP or   *
  *                      TIMESTAMP(6) data-type for the          *
  *                      parameter of an external SQL procedure. *
  *                                                              *
  *                      An example:                             *
  *                                                              *
  *                      CREATE PROCEDURE                        *
  *                      ProcedureA                              *
  *                      (IN PARM1 TIMESTAMP(0)                  *
  *                      WITHOUT TIME ZONE)                      *
  *                      EXTERNAL NAME 'NAMEA'                   *
  *                      LANGUAGE SQL                            *
  *                      ...                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When creating DDL for an external SQL procedure, the TIMESTAMP
  data-type was generated as TIMESTAMP(0) instead of TIMESTAMP or
  TIMESTAMP(6).
  

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:

  UK83596 UK83597

Modules/Macros

•    ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK83596

     UP12/11/21 P F211

• RA20 PSY UK83597

     UP12/11/21 P F211

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.