When the statement executes successfully, the changes are defined to CA Datacom Datadictionary in PRODuction status and cataloged to the CA Datacom/DB Directory (CXX).
You can use the other modes of CA Datacom Datadictionary to add support data, such as aliases, descriptors, additional relationship definitions, and text. For information on enhancing the table definitions, see the CA Datacom/DB Database and System Administration Guide and the CA Datacom Datadictionary User Guide.
If the ALTER TABLE statement cannot complete, it is rolled back to its beginning. If the ALTER TABLE process is force checkpointed (because of the size of the Log Area (LXX) and the concurrent activity), the rollback is incomplete. Therefore, before altering large tables ensure that the Log Area (LXX) is large enough and take a backup of the data area.
|
Copyright © 2014 CA.
All rights reserved.
|
|