PM16123: DSQ17798 EDIT TABLE FOR TABLE WITH GENERATED ALWAYS COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF Edit Table issues message:
  Attempted to insert a value into ROWID GENERATED ALWAYS column.
  for Tables with GENERATED ALWAYS columns.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V9 and V10 users.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE-798 was received in QMF Table   *
  *                      Editor ADD mode on a column defined     *
  *                      TIMESTAMP GENERATED ALWAYS.             *
  *                      Message DSQ17798 for SQLCODE-798        *
  *                      error indicated error data type was     *
  *                      ROWID. SQLCODE798 MSGDSQ17798           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  More data types than just ROWID can be defined as GENERATED
  ALWAYS and can therefore receive an SQLCODE-798 if an attempt
  is made to INSERT or UPDATE a column thus defined.  QMF was
  not checking for data types other than ROWID in Table Editor
  processing, and thus not processing those data types correctly
  in Table Editor.
  Also, message DSQ17798 was hardcoded to indicate the -798 was
  for the ROWID data type.  Data types other than ROWID can be
  defined as GENERATED ALWAYS.
  

Problem conclusion

• Table Editor processing has been altered to check the
  value in the DEFAULT field of SYSIBM.SYSCOLUMNS for each
  column in a table to determine if it was defined as
  GENERATED ALWAYS, irrespective of its data type.
  
  References to a specific data type were removed from Message
  DSQ17798.  Examples were added.
  

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:

  UK58631 UK58632

Modules/Macros

• DSQCELTT DSQCEMSG DSQFSDB2 DSQFSDB8 DSQGDRCI
  DSQGDRIP DSQGDRQM DSQGSDB2 DSQIISQL DSQISDB2 DSQISDB8 DSQPNLE
  DXYE0879
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK58631

     UP10/07/09 P F007

• R910 PSY UK58632

     UP10/07/09 P F007

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.