Data Build Manual

File Names in DEFINES and PATHCNFG Files
Understanding Data Build Files
2–8 099331 Tandem Computers Incorporated
File Names in
DEFINES and
PATHCNFG Files
The actual file or table can be named different than the DEFINE name and each can be
on any subvolume except in the following cases:
For non-IXF disk input (Enscribe or NonStop SQL output):
Data Build checks for every file name with the prefix specified in the Conversion
Environment screen ending in a number from 00 to 99. If no file exists that
matches this name, Data Build displays an error message. You can ignore the
error message or set up a dummy file with the name.
For IXF disk input, each input file must be named the same as the DEFINE name.
For IXF tape input, Data Build creates one working file for each input file dataset.
The H (Header), T (Table) and C (Column) records from each IXF input dataset are
saved in each working file. The name you specify as the input file prefix on the
Conversion Environment screen is used only for these working files. You can
specify anything you want, such as DUMMY. Data Build gets the input files
directly from the tape.
Sample DEFINES File The DEFINES file is created and customized when you run the Project utility. The
Project utility modifies the file to include the project subvolume and the SQL
subvolume that you specified when running Project. Here is the sample DEFINES file
that comes with Data Build.
SET DEFMODE ON
DELETE DEFINE =CAT
ADD DEFINE =CAT, CLASS CATALOG, SUBVOL $DATA.MKDBL1S
DELETE DEFINE =DATAIN01
ADD DEFINE =DATAIN01, CLASS MAP, FILE $DATA.MKDBL1.DATAIN01
...
DELETE DEFINE =DATAOT01
ADD DEFINE =DATAOT01, CLASS MAP, FILE $DATA.MKDBL1.DATAOT01
Sample PATHCNFG File Here is the sample PATHCNFG file that comes with Data Build:
RESET SERVER
SET SERVER DEFINE =DATAIN01, CLASS MAP, FILE $DATA.MKDBL1.DATAIN01
SET SERVER DEFINE =DATAIN02, CLASS MAP, FILE $DATA.MKDBL1.DATAIN02
SET SERVER DEFINE =DATAIN03, CLASS MAP, FILE $DATA.MKDBL1.DATAIN03
SET SERVER DEFINE =DATAOT01, CLASS MAP, FILE $DATA.MKDBL1.DATAOT01
SET SERVER DEFINE =DATAOT02, CLASS MAP, FILE $DATA.MKDBL1.DATAOT02
SET SERVER DEFINE =DATAOT03, CLASS MAP, FILE $DATA.MKDBL1.DATAOT03
SET SERVER DEFINE =DEMO01, CLASS MAP, FILE $DATA.MKDBL1.DEMO01
SET SERVER DEFINE =DEMO02, CLASS MAP, FILE $DATA.MKDBL1.DEMO02
SET SERVER DEFINE =DEMO03, CLASS MAP, FILE $DATA.MKDBL1.DEMO03
SET SERVER DEFINE =CAT, CLASS CATALOG, SUBVOL $DATA.MKDBL1S
...
ADD SERVER RUN-PROC-DCNVT