Data Build Manual

Where to Go Next
Running the Sample Programs
5–18 099331 Tandem Computers Incorporated
The conversion program converts the data in the three sample files: DATAIN01,
DATAIN02, and DATAIN03. Data Build stores the data from each input file in a
corresponding output file: DATAOT01, DATAOT02, and DATAOT03. As each file is
converted, you will see the number of records converted. Remember, the file DEFINE
names of the input and output files are specified in the Conversion Environment
screen, so Data Build knows where to store the converted data.
Checking the Data To verify that the conversion was successful, check the output data. For example,
check the Enscribe conversion output file DATAOT01 by using FUP.
To check output file DATAOT01, follow these steps:
1. Exit Data Build by pressing SF16 (EXIT).
2. Use the FUP COPY command to display the first five records of the output file.
Enter the following at the TACL prompt:
1> FUP COPY dataot01 ,,H,COUNT 5
This displays the contents of the first five converted records in output file DATAOT01,
in both hexadecimal and character format.
Where to Go Next You have created a COBOL85 conversion program that converts the sample input files
and writes the output data to an Enscribe database. The next section shows you how
to create a COBOL85 conversion program that loads data to a NonStop SQL database.
Sample Data
Conversion to
NonStop SQL
This section shows you how to create a COBOL85 conversion program to convert the
sample data input files and load the data to NonStop SQL tables.
Input Files The input files for the NonStop SQL sample conversion are the same as for the
Enscribe sample The three sample input files are DATAIN01, DATAIN02, and
DATAIN03.
Notice that the three samples files have the same six character prefix DATAIN and are
numbered sequentially 01, 02, and 03. Although the sample input files begin with six
characters, the input file names can begin with one to six characters. The numbering
of the Source Record Descriptions files correspond with the input files. For example,
the Source Record Descriptions file for DATAIN01 will be RECDEF01.
Source Record
Descriptions
The source record descriptions tell Data Build the format of the records in the input
data files from the non-Tandem system. This subsection shows you one of the sample
source record descriptions that is provided by Data Build.
To look at the Source Record Descriptions file, do the following:
1. Volume to the conversion project subvolume.
2. Use the editor to look at the Source Record Descriptions files RECDEF03.