PM90042: SQLCODE -180 THE DATE, TIME, OR TIMESTAMP VALUE *N IS INVALID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Editing a table with a column defined as "TIMESTAMP(n) NOT NULL"
  or "TIMESTAMP(n) WITH TIME ZONE NOT NULL" and inserting a new
  row but leaving the column blank will result in the following
  error:
  SQLCODE -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE *N IS
  INVALID
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Optim/z users editing a DB2 table with a column defined as   *
  * "TIMESTAMP(n) NOT NULL" or "TIMESTAMP(n) WITH TIME ZONE NOT  *
  * NULL" (neither having the "WITH DEFAULT" clause).            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Optim/z users editing a DB2 table with a column defined as   *
  * "TIMESTAMP(n) NOT NULL" or "TIMESTAMP(n) WITH TIME ZONE NOT  *
  * NULL" (neither having the "WITH DEFAULT" clause) and         *
  * inserting a new row but leaving the column blank will result *
  * in an SQLCODE -180 error with the following message:         *
  * "SQLCODE -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE *N  *
  * IS INVALID"                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the provided fix.                                      *
  ****************************************************************
  Optim was formatting the generated TIMESTAMP value incorrectly
  while building the SQL "INSERT" statement.
  

Problem conclusion

• The code has been modified to format the value correctly.
  

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:

Modules/Macros

• FOPMDMAI FOPMECMN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• R710 PSY UK95895

     UP13/07/18 P F307

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.