Data Build Manual

Customizing SQL-LOAD Output
Customizing Data Build
099331 Tandem Computers Incorporated 6–19
But first, run without modification the sample data provided by Data Build.
1. RUN PROJECT to set up a conversion project subvolume.
The DEFINES and PATHCNFG files are initially setup for the sample data and the
NSSQL tables are created.
2. Set the default subvolume to the conversion project subvolume.
3. OBEY XSTART to start the Pathway System.
4. OBEY XRUN to start Data Build.
5. Press F1 (for the Configuration Environment screen). For Option 1, specify either:
SQL-LOAD, and for Option 2 specify SORTED or leave it blank
SQL-INSERT
6. Press F14, to update the configuration, then F16, to return to the Main Menu.
7. Press F2, F3, F4 and F5 consecutively. Check the spooler (press F12) for errors
after each step.
8. Press F11 for SQLCI and enter the following commands to send the first 7 rows to
the spooler at #DEM1BE4:
SET LIST_COUNT 7;
OUT $S.#DEM1BE4;
SELECT * FROM =DEMO01;
EXIT;
This will show the data for comparison after the example is run.
9. Press F16 to exit Data Build.
Running the Example
1. Edit TBLSRC and change:
Before ...
,DEM1_NAME CHAR (25) NOT NULL,
After ...
,DEM1_NAME VARCHAR (25) NOT NULL,
2. OBEY XTBLSRC to change the SQL table definition.
3. OBEY XRUN to start Data Build.
4. Press F2 to build and compile the DDL.
We will use the same F1 (Configuration Environment) settings as for the previous
unmodified sample data run. This F2 step will yield the same results as when the
samples were previously run.
5. Press F16 to exit Data Build.