PI41215: DSQ36798 SQLCODE: -798 ADDING ROWS IN THE QMF TABLE EDITOR WHEN A COLUMN IS DEFINED AS NOT NULL GENERATED ALWAYS AS .....

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When adding rows through the QMF table editor (MODE=ADD), the
  user is forced to enter a value for any columns defined as
  NOT NULL GENERATED ALWAYS AS. This results in a MSGDSQ36798
  SQLCODE798 and the user is unable to add rows to the table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10.1 users.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the table editor to add a    *
  *                      row to a table with columns defined     *
  *                      like 'TIMESTAMP (12) WITHOUT TIME ZONE  *
  *                      NOT NULL GENERATED ALWAYS', user        *
  *                      received error message DSQ36798.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a user tries to run the 'EDIT TABLE xxx (MODE ADD)' command
  against a table that has columns defined with NOT NULL
  GENERATED ALWAYS, the table editor is presenting the user with
  unprotected edit fields for the NOT NULL GENERATED ALWAYS
  columns. The unprotected fields allow the user to potentially
  enter values for those columns. If the user enters nothing for
  the field, they will get DSQ84531 'This field cannot be null.'
  If they enter a valid value, they will get DSQ36798 (SQLCODE798)
  stating 'A value cannot be specified for a column that is
  defined as GENERATED ALWAYS.'. The user has no way to insert a
  row to the table.
  

Problem conclusion

• When processing tables containing columns defined as GENERATED
  ALWAYS, the table editor should protect the fields and handle
  the INSERTS for the end user. The QMF V10 table editor code has
  been updated to protect the fields and INSERT a DEFAULT value.
  

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:

  UI27778

Modules/Macros

• DSQGSDB2 DSQISDB2
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UI27778

     UP15/05/22 P F505

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.