Incorrect DDL for ROW CHANGE TIMESTAMP columns using RC/Query

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

When using RC/Query to generate DDL for columns defined as ROW CHANGE TIMESTAMP in DB2 for z/OS, the output is incorrect and does not conform to expected syntax. 

Environment

Product: RC/Query
Platform: DB2 for z/OS

Cause

A product defect in RC/Query causes incorrect syntax generation for columns defined as FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP.

 

Resolution

Apply PTF LU20686 to resolve the issue. This fix ensures that RC/Query correctly identifies ROW CHANGE TIMESTAMP columns and generates the proper DB2 for z/OS syntax, including the `GENERATED BY DEFAULT` and `FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP` clauses.