DSF Return Codes › ALT

ALT

ALTERED TABLE CANNOT BE COPIED

Reason:

A table is being copied from TEST status to PRODuction status that had been altered using SQL processing since the last copy to PRODuction status.

Action:

Restore the table from PRODuction status to TEST status and make the updates before attempting to copy the table to PRODuction status again. However, any changes that have been made to the TEST status version is lost.

Alternately, if the changes through SQL processing are more easily re-created, do the following:

1. Drop all constraints from the PRODuction status version. When the last constraint is dropped, the constraint attribute-value is reset to N for all copies.
2. Copy the TEST status version to PRODuction status.
3. Add the constraints that were dropped.

   If the intent is to continue making changes to the TEST status version, continue to the following steps:

   1. Delete all TEST status versions.
   2. Restore the current PRODuction status version to a TEST status.
   3. If any ALTER TABLE processing is required (to add more constraints for example), repeat Step 3a after completing the ALTER TABLE statement(s).