PH44864: DB2 AOC: SYSTIMESTAMP NOT SUPPORTED AS SPECIAL REGISTER

APAR status

• Closed as program error.

Error description

• Db2 AOC: SYSTIMESTAMP not supported as special register
  
  
  DESCRIPTION:  Running GEN on a view using SYSTIMESTAMP as an
  alternative to CURRENT_TIMESTAMP may result in errors or
  warnings.  The parser currently does not support SYSTIMESTAMP as
  a special register.  This APAR will support SYSTIMESTAMP in GEN
  as a special register (similar to SYSDATE, or
  CURRENT_TIMESTAMP).
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DDL Generator (GEN) might fail if   *
  *                      the keyword SYSTIMESTAMP is included in *
  *                      the definition of a view.               *
  ****************************************************************
  The DDL parser does not support the keyword SYSTIMESTAMP as a
  special register. When you run GEN on a view whose definition
  includes the keyword SYSTIMESTAMP and a RUNSQLID is specified,
  the following error message will be returned:
  
  ADB1847E A parser error has occurred for the following view.
           GEN cannot complete the request.
           Reason code = 8
           >current_SQLID<.>view_name<
  
  When you run GEN on a view whose definition
  includes the keyword SYSTIMESTAMP and a RUNSQLID is not
  specified, the following warning message will be returned:
  
  ADB1848W Unformatted DDL will be generated for the following
  view because it could not be parsed. Please verify the DDL.
  
  Reason code = 28
  >current_SQLID<.>view_name<
  
  Keywords: GEN SYSTIMESTAMP MSGADB1847E MSGADB1848W
  

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:

  UI80425

Modules/Macros

• ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels