PH44937: DB2 ADMIN: MISSING DATE / TIME FORMAT IN STORED PROCEDURE DDL GENERATION

APAR status

• Closed as program error.

Error description

• Missing DATE / TIME FORMAT in Stored Procedure DDL
  
  DESCRIPTION:  In the output of the Stored Procedure DDL
  generation (ADB2GEN) the options DATE FORMAT and TIME FORMAT are
  missing because Db2 does not save the value of these two fields.
  The code will be updated to take the values from the original
  SQL statements.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who generate DDL for stored procedures       *
  *                 (panel ADB2GEN)                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The generated DDL for a stored          *
  *                      procedure is missing the DATE FORMAT    *
  *                      and TIME FORMAT options.                *
  ****************************************************************
  When the DDL or GEN line command is issued on a stored
  procedure, the DDL that is generated by the ADB2GEN process is
  missing the DATE FORMAT and TIME FORMAT options.  Db2 Admin Tool
  should generate these options for stored procedures.
  

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:

  UI80429

Modules/Macros

• ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels