Data Build Manual

Running the Conversion Program (F5)
Running Data Build
4–16 099331 Tandem Computers Incorporated
Running the
Conversion Program
(F5)
In step F5, you will use the COBOL85 conversion program to convert the input files.
You should have checked for errors and corrected them after each step in the
conversion process. If you did not correct the errors, the conversion program will not
properly convert the input files.
To convert the input files:
1. Press F5 to run the conversion program.
Data Build converts the input files and creates the Tandem database you specified.
For example, if you specified an SQL-LOAD conversion program, Data Build will
load the data to NonStop SQL tables.
2. Exit from Data Build and check the converted data.
Output Statistics In the F5 Run step, Data Build sends a count of the input and output records to the
terminal and to the spooler location #RUN.
For non-IXF input, the input and output counts should be the same. For IXF input, the
output count will be less than the input count. The difference is 1 for the IXF H
(Header) record, 1 for the IXF T (Table) record and 1 for each IXF C (Column) record.
The difference less 2 is the number of columns in the source table which will be the
same as the output NonStop SQL table unless you modify it:
Type of Input Input Count vs. Output Count
Non-IXF Input and output count same
IXF Output = Input count minus 2 minus the
number of columns
Note that for SQL-LOAD (either IXF or non-IXF input,) the output count represents
the number of records sent to the SQLUTIL process. Check the spooler location
#ZZLOAD for the number of SQL rows loaded. It should be the same as the output
count.
Checking the
Converted Data
The converted data is now in the output files or the NonStop SQL tables that Data
Build created. How you check the data will be different depending on whether Data
Build created an Enscribe or a NonStop SQL database.
If you converted the data to an Enscribe database, you must check each output file.
The FUP COPY command will display the records from the output files. See the File
Utility Program (FUP) Reference Manual for more information.
If you loaded or inserted the data to NonStop SQL tables, use SQLCI to select data
from the tables. For more information on SQLCI, see the NonStop SQL Conversational
Interface Reference Manual.