Data Build Manual

Summary
Running the Sample Programs
099331 Tandem Computers Incorporated 5-27
The conversion program converts the data in sample files DATAIN01, DATAIN02,
and DATAIN03. Data Build programmatically loads the data to the NonStop SQL
tables you specified—DEMO01, DEMO02, and DEMO03. The DEFINES file names
these tables. Data Build creates tables with these defaults: entry-sequenced, extents
and maxextents, buffered, no audit, and no indexes. The NonStop SQL defaults are
specified in the file TBLSRC.
Checking the Data You can use SQLCI to check the data in the NonStop SQL tables to verify that the data
was converted properly.
To check the data in the NonStop SQL tables, follow these steps:
1. Exit Data Build.
2. Enter OBEY DEFINES.
3. Run SQLCI.
4. Select the data from the table by entering the following SELECT statement:
>>select * from =DEMO01;
SQLCI displays a list of data from the table DEMO01 at your terminal. You can
use SQLCI to examine the other two tables: DEMO02 and DEMO03.
5. When you finish checking the data, enter END to exit SQLCI.
Summary If you completed both sample data conversions, you created two different types of
Data Build conversion programs and have converted the sample input files. First you
converted the sample input files with the Enscribe conversion program. Then you
created an SQL-LOAD conversion program and converted the sample input files. As a
result, you created an Enscribe database and a NonStop SQL database.