Creating SQL Objects › Creating a Table › Statement Execution Results

Statement Execution Results

When the statement executes successfully, the table, columns, key, and element are defined to CA Datacom Datadictionary in PROD 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. You can rename keys, change keys, and add more keys to the table using the other modes of CA Datacom Datadictionary.

To add additional keys or elements, copy the PROD status version of the table to a TEST status, make your modifications, and catalog the table using the CA Datacom Datadictionary CATALOG function.

Note: For information on enhancing the table definitions, see the CA Datacom/DB Database and System Administration Guide and the CA Datacom Datadictionary User Guide.