PH40627: SQLCODE = -313 ERROR UPDATING A DB2 TABLE WITH TEMPORAL COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User is attempting an update of a DB2 table with temporal
  columns. The table does not have a PK defined, DB2 or Optim.
  The update attempt fails with SQLCODE=-313.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users editing DB2 tables with temporal *
  *                 columns.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Optim may produce SQL errors while      *
  *                      editing a DB2 table.                    *
  ****************************************************************
  Optim is creating an invalid SQLDA area when updating DB2 tables
  with temporal columns.
  

Problem conclusion

• Optim processing logic will be corrected.
  

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:

  UI77504

Modules/Macros

• FOP1OSFN FOP9APIM FOPCFPMN FOPHSTM  FOPMAIN  FOPMCMAI FOPMDMAI
  FOPMMUNU FOPOMN   FOPRS10  FOPZMAIN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI77504

     UP21/10/09 P F110

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.