SAP Knowledge Base Article - Preview

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

Symptom

  • 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;


Read more...

Environment

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

Product

SAP PowerDesigner all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.