A fix is available
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 number
PI41215
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-05-15
Closed date
2015-05-19
Last modified date
2015-06-01
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 June 2015