2354536 - DB2 for z/OS table is dropped when a row change timestamp column is added - SAP PD

• IBM DB2 Version for z/OS uses the ALTER TABLE statement to add a row change timestamp column, defined using either of the following statement clauses:

NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP

NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP

• Table is dropped then recreated when a row change timestamp column is added.
• SAP PD should generate:

ALTER TABLE tablename
     ADDcolumnname TIMESTAMP NOT NULL
      GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP;

• SAP PowerDesigner (PD) 16.6
• IBM DB2 Version for z/OS

drop, new, modify, modified, identity, 801052, CR801052, CR#801052 , KBA , BC-SYB-PD , PowerDesigner , Problem