Always generate and install the database before attempting to install programs that use the database. Ensure that the database is installed and active.
Keep test data files small to avoid writing conversion routines, although this is done as part of the project. When possible, share test files with others using the same data to increase productivity.
Use Generate and Install All DDL with DROP statements to replace a previous version of the installed table. Set the DROP statement in the DDL option to Yes on the Testing Environment Panel.
When regenerating a database definition, specify DROP. Create a separate routine outside CA Gen to save data in a database before regenerating. Use the DBMS' import/export facility or write a conversion program.
Detail DDL Generation enables you to generate and, optionally, install a table or an index at a time. If you use this option, be sure to include all changes.
You employ this option to generate new indexes representing newly created entry points without dropping the base tables upon which they are built.
The Generate and Install All DDL option reduces the number of difficult-to-locate integrity problems in the generated database definition.
When you receive a message beginning with the word Errors:, the installation process failed. To determine the failure reason, review the results of the installation. Normally a problem is the result of an environmental error of some kind. For example, your DBMS was not properly started, or a table exists that has the same name as the one being generated.
If you regenerate DDL, be sure to regenerate RI triggers.
