In order to avoid referencing this generated DB2 field in your edit , RC/Update has the ability to ignore this column. This will allow DB2 to handle it as it should when a record is inserted in the table.
The column can be un-selected for the edit.
When an Edit of the table is started the RC/Edit Options screen is displayed, Use the EQF to un-select this column. Enter "Y" in the Where field displayed.
Data Selection
Where ==> Y
Then the Data Query Edit screen is displayed.
Sample column list below. Note column TSCDC. This one is a generated column defined as:
TSCDC TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP IMPLICITLY HIDDEN
Sel C Ord Column Name Type
S __ 1 GROUP_ID D(6,0)
S __ 2 PLATFORM_CD C(1)
S __ 3 TSCDC TIMEST>
S __ 4 GROUP_NAME C(60)
S __ 5 GRP_MBR_COUNT D(7,0)
S __ 6 CALC_COV_TYPE_IND C(1)
S __ 7 TERM_DEP_IND C(1)
Overwrite the "S" in the "SEL" column with a space on the line containing column
TSCDC which you don't want to edit anyway.
Sel C Ord Column Name Type
S __ 1 GROUP_ID D(6,0)
S __ 2 PLATFORM_CD C(1)
__ 3 TSCDC TIMEST>
S __ 4 GROUP_NAME C(60)
S __ 5 GRP_MBR_COUNT D(7,0)
S __ 6 CALC_COV_TYPE_IND C(1)
S __ 7 TERM_DEP_IND C(1)
PF3 back to the edit data screen where new rows can be inserted as normal and column
TSCDC will be handled by DB2.
New rows can then be added. In order to use the EQF again it can be saved by giving it a name and making it the Default EQF for this table when next it is editted.