Tips for DBAs: Best Practices

Use the following guidelines:

Assign tables that are required by a single procedure to the same database during unit testing.
If you change table names, column names, or column properties outside CA Gen, be sure to make corresponding changes in the Data Structure List and then install them using the system-generated DDL. This ensures that the system-generated programs run against the database.
If you make the table or column name changes by changing the DSD names in the data model before to transformation, be sure to make corresponding changes in the Data Structure List. CA Gen uses DSD names when it transforms.
If you change a table or column name after transformation, do so by changing the table name or column name in the Data Structure List. CA Gen does not use DSD names during retransformation.
If an attribute is added to an existing transformed entity type, be sure to resequence attributes of retransformed entity types in the Data Structure List. Retransformation puts the added attribute's column at the end of the list.
If any change is made to Referential Integrity (RI) rules on the data model, be sure to run retransformation or the RI process.
If DBMS RI is chosen, alter the existing tables ensure that they are defined with the most current delete rules.

Consult your DBMS reference guide for other recommendations.