Data Build Manual

Customizing SQL-LOAD Output
Customizing Data Build
099331 Tandem Computers Incorporated 6–23
To run this example, perform the following steps:
1. Edit TBLSRC and change to make DEM1_NAME nullable VARCHAR:
Before ...
,DEM1_NAME CHAR (25) NOT NULL,
After ...
,DEM1_NAME VARCHAR (25),
2. OBEY XTBLSRC to change the SQL table definition.
Press F1 (for the Configuration Environment Screen). For Option 1, specify SQL-
LOAD (not SQL-INSERT), and for Option 2 specify SORTED or leave it blank.
Press F14, to update the configuration, then F16, to return to the Main Menu.
We will use the same F1 (Configuration Environment) settings as for the previous
unmodified sample data run. This F2 step yields the same results as when the
samples were previously run.
4. Press F2 to build and compile the DDL.
5. Press F16 to exit Data Build.
6. Edit DDLDEF01 and change ?SECTION OUT-DEMO01
Before ...
06 DEM1-NAME-X.
07 DEM1-NAME PIC X(25).
After ...
06 DEM1-NAME-X.
07 DEM1-NAME.
08 LEN PIC S9(4) COMP.
08 VAL PIC X(25).
7. Run the following:
DDL /IN ZZDDLIN, OUT $S.#DDLNEW/
Check the spooler location #DDLNEW and correct any errors.
8. OBEY XRUN to start Data Build
9. Press F3 to generate PROCLIB.
10. Respond “Y” to Purge USERLIB, at the prompt:
GENPROC: User Library Exists - $Vol.subvol.USERLIB
GENPROC: If You Wish To Purge, Enter Y/N...
USERLIB is a skeleton file created during the F3 step when the previous samples
were run. “Y”purges the current file and creates the skeleton file.
11. Press F16 to exit Data Build.