Adding a Non DMSII Column

The following script demonstrates how to add a non DMSII column to a relational database table.

This script adds three non DMSII columns (update_type, audit_ts, and delete_record) to the ORDERS data set and preserves all deletes, including multiple deletes with the same key value, since bit column 10 becomes a new key item with a unique value.

File name: script.user_layout.orders

update DATASETS set external_columns = 521
where dataset_name = ‘orders’