Data Build Manual

Where to Go Next
Running the Sample Programs
5–26 099331 Tandem Computers Incorporated
Creating the SQL-LOAD
Conversion Program
Pressing F4 creates the data conversion program. Data Build uses the procedures from
PROCLIB, created in the F3 step, to create and compile a COBOL85 data conversion
program.
To create the conversion program, do the following:
1. Press F4 at the Main Menu.
Data Build displays the progress on your terminal showing the starting and
stopping time stamps. The display information is simultaneously logged to the
spooler.
2. Press any key to return to the Main Menu. At the bottom of the Main Menu, this
message is displayed:
CREATE Complete — CHECK RESULTS ON SPOOLER.
3. Press F12 to run Peruse. The spooler output is sent to three locations, #PROGM1,
#PROGM2, and #PROGM3, because there is a three-stage SQL compile.
#PROGM2 is the actual data conversion program.
4. Check the spooler locations for NonStop SQL errors or warnings. If you find any
errors, correct them before continuing.
5. Exit the spooler and return to Data Build.
Refer to Appendix B, “Sample Conversion Programs,” for the SQL-LOAD sample
conversion program.
Running the SQL-LOAD
Conversion Program
Pressing F5 runs the data conversion program created in the last step. To run the data
conversion program, follow these steps:
1. Press F5 at the Main Menu.
Data Build displays the progress on your terminal, showing the starting and
stopping time stamps. The display information is simultaneously logged to the
spooler.
2. Press any key to return to the Main Menu. At the bottom of the Main Menu, this
message is displayed:
RUN Complete — CHECK RESULTS ON SPOOLER & VERIFY OUTPUT
FILES
3. Press F12 to run Peruse. The spooler output is at location #RUN.
4. Check #RUN for errors. If you find errors, you should correct them. Then rerun
the conversion program to convert the input files.
5. Exit the spooler and return to Data Build.