A fix is available
APAR status
Closed as program error.
Error description
When a column is defined as GENERATED ALWAYS, the user cannot edit and add a new row because FM/DB2 build SQL INSERT statement with data in the fields that are defined GENERATED ALWAYS. DB2 does not accept this.
Local fix
To bypass the trouble and depending on the amount of data you have to put in a row, you can the use a SQL INSERT with the 'default' parm. For example: Under File Manager/DB2, choose option 4 (SQL) then 3 (Enter). Enter: INSERT INTO tablename VALUES(n, n, 'xxx', default) When you get the message "INSERT executed successfully", hit PF3 otherwise you will add a new line with the same data.
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: In FM/DB2 edit, SQLCODE-798 attempting * * to insert a row into a table with a * * column defined with 'FOR EACH ROW ON * * UPDATE GENERATED ALWAYS'. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** File Manager DB2 component is not correctly handling columns marked with SYSIBM.SYSCOLUMNS.DEFAULT='E'
Problem conclusion
File Manager DB2 component has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PM31152
Reported component name
FILE MANAGER ZO
Reported component ID
5655V5200
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-01-25
Closed date
2011-04-18
Last modified date
2011-05-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN2LVL
Fix information
Fixed component name
FILE MANAGER ZO
Fixed component ID
5655V5200
Applicable component levels
RA12 PSY UK66840
UP11/04/20 P F104
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":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 May 2011