A SQLCODE = -798 sql code is seen when inserting or updating a row in a table where a value was specified for a column that is defined with GENERATED ALWAYS attributes and its value is not being set with the DEFAULT keyword. GENERATED ALWAYS columns should not be specified in the column list for an insert operation, or in the SET clause for an update operation unless the keyword DEFAULT is specified.
In RC/Update for Db2 for z/OS (RCQ), by default, all columns are selected therefore the best way around this is to unselect a column.
In RC/Edit we are getting the following error message: SQLCODE = -798, ERROR: A VALUE CANNOT BE SPECIFIED FOR COLUMN TSCDC WHICH IS DEFINED AS GENERATED ALWAYS
The field is defined as follows: TSCDC TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP IMPLICITLY HIDDEN
Db2 for z/OS
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)
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)