Data Build Manual

Where to Go Next
Running the Sample Programs
5–20 099331 Tandem Computers Incorporated
The following DEFINEs name each table:
DELETE DEFINE =DEMO01
ADD DEFINE =DEMO01, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO01
DELETE DEFINE =DEMO02
ADD DEFINE =DEMO02, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO02
DELETE DEFINE =DEMO03
ADD DEFINE =DEMO03, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO03
When you convert data, you can easily change the existing DEFINEs or add new ones
if necessary to the DEFINES file.
The PATHCNFG File The PATHCNFG file, a Pathway configuration file, defines Data Build’s Pathway
parameters. Certain information in this file, such as $CONVERT.SUBVOL, uses the
information you entered in the Project Utility screen. Data Build updates the
PATHCNFG file with the information you gave.
To look at PATHCNFG, do the following:
1. Make sure you are at the conversion project subvolume.
2. Use the editor to look at the PATHCNFG file.
The PATHCNFG file, like the DEFINES file, was created for the sample conversions.
This file specifies the location of the NonStop SQL catalog, the input files, output files,
and NonStop SQL tables.
The following DEFINEs in PATHCNFG specify the input files:
SET SERVER DEFINE =DATAIN01, CLASS MAP, FILE $CONVERT.SUBVOL.DATAIN01
SET SERVER DEFINE =DATAIN02, CLASS MAP, FILE $CONVERT.SUBVOL.DATAIN02
SET SERVER DEFINE =DATAIN03, CLASS MAP, FILE $CONVERT.SUBVOL.DATAIN03
The statements for the output files are not used in this conversion. In this conversion,
the data will be loaded to NonStop SQL tables. Because the output is loaded to
NonStop SQL tables, each table is named in a separate DEFINE like this:
SET SERVER DEFINE =DEMO01, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO01
SET SERVER DEFINE =DEMO02, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO02
SET SERVER DEFINE =DEMO03, CLASS MAP, FILE $CONVERT.SQLCAT.DEMO03
Note that the DEFINE table names in PATHCNFG are the same as the output table
name in the Source Record Descriptions file. For example, in RECDEF03 the table
name was DEMO03 and that table name appears here in the DEFINE.
NonStop SQL
Catalog and Tables
For a conversion to NonStop SQL when the input data is not in IXF format, you must
create the NonStop SQL table(s). This can be done by creating an EDIT file with a
NonStop SQL CREATE TABLE statement for each table and processing the file with
SQLCI. If the source data is DB2, the Tandem CREATE TABLE statements are similar
to and can be a modified copy of the DB2 CREATE TABLE specification.