Data Build Manual

Where to Go Next
Running the Sample Programs
5–24 099331 Tandem Computers Incorporated
Configuring the
Conversion Environment
Pressing F1 lets you configure the Conversion Environment. The Conversion
Environment is where you define the settings for this conversion project, such as the
names and locations of the input, output, DDL record definitions, and Source Record
Descriptions files.
To configure the Conversion Environment, follow these steps:
1. Press F1 at the Main Menu to display the Conversion Environment screen, shown
earlier in Figure 5-2. Your screen will look different than Figure 5-2 because it will
match your system environment.
The initial settings in Conversion Environment screen are for the sample
conversions. You will change the settings for your own conversion project.
2. For this conversion, you are creating a conversion program that loads data to
NonStop SQL tables. You need to specify this type of conversion program. In
OPTIONS 1, enter SQL-LOAD.
3. If you know that the source data is sorted in the key sequence for loading to a
NonStop SQL table, enter SORTED in OPTIONS 2.
If you do not specify SORTED, SQLCI sorts the data before loading it.
If you had specified SQL-INSERT in OPTIONS 1, and left OPTIONS 2 blank, Data
Build would create a data conversion program that inserts the data into a NonStop
SQL database.
4. To save the changes in the Conversion Environment, press F14 (Update).
5. Press F16 (RETURN) to exit the Conversion Environment screen and return to the
Main Menu.
At the bottom of the Main Menu, this message is displayed:
CONFIGURE Complete - PLEASE PROCEED
You should be at the Main Menu and ready to build the input for DDL.
Building DDL Input Pressing F2 builds the DDL data definitions files and runs the DDL compiler. To build
input for DDL, Data Build takes the Source Record Descriptions files and builds a
dictionary that describes the data in a uniform manner.
DDL takes the source record descriptions and translates the record descriptions into a
data definition format. DDL creates input files DDLDEF01, DDLDEF02, and
DDLDEF03, and passes them as input to the DDL compiler.
To build input for the DDL and generate DDL output, follow these steps:
1. Press F2 at the Main Menu.
Data Build displays the step-by-step progress on your terminal showing the
starting and stopping time stamps. The displayed information is simultaneously
logged to the spooler.