The steps for creating and installing a database are as follows:
Ensure that you have specified the correct operating system and database management system (DBMS) to be used for implementation.
If you are creating a new database remote file for remote installation, do not generate DROP statements in the DDL. DROP statements that appear in a DDL remote file that was not previously installed could cause the implementation to fail.
If you are creating a database remote file for remote installation, specify not to qualify tables and indexes with your owner ID. This is useful only when testing an application on your workstation.
When the DDL is generated with the owner ID included in the table and index names, there may be difficulty installing the DDL unless the ID of the user installing the DDL is the same as the user ID found in the generated DDL.
If you receive a Consistency Check error message during construction that relates to database structure inconsistencies, return to the Design Toolset and retransform your Technical Design (TD). For more information about retransformation, see Toolset Help.
