Building a Database › Design Construction Process

Design Construction Process

The design used by the Construction process to build the database Data Definition Language (DDL) is the Technical Design (TD) as shown in the following illustration. The type of DDL generated by CA Gen is Structured Query Language (SQL).

The following diagram shows an overview of a database build:

A database must be present before you can install your application if:

• The application has database access statements (SQL calls) in it.
• The application is a character-based (block mode) application that requires a profile table. For more information, see the appendix “Load Module Structure.”

You can install the generated DDL for a local installation or a remote installation. For a local install, installation builds the database, tables, and indexes on your workstation. For a remote install, installation creates a remote file that you then transfer to your target system. On the target system, the Implementation Toolset unpacks the remote file and builds the database.

Note: You must choose Install to get a remote file when generating for remote installations.