Data Build Manual

Tape Input
Understanding Data Build Files
2–10 099331 Tandem Computers Incorporated
Tape Input The following DEFINE is included in the DEFINES file based on the tape device
location you specified when you ran the Project utility:
DELETE DEFINE =TAPE
ADD DEFINE =TAPE, CLASS TAPE, LABELS BYPASS, DEVICE \system.$device
The same DEFINE is also included in the PATHCNFG file as follows:
SET SERVER DEFINE =TAPE,CLASS TAPE,LABELS BYPASS,DEVICE \system.$device
If the DEFINEs are not correct, correct the DEFINES and PATHCNFG files before you
obey XSTART.
If the input is on tape, you must set Option 4 to =TAPE and on the conversion
environment (F1) screen.
Non-IXF Data The IN Data Files specification on the CONFIGURE (F1, Conversion Environment)
Screen is required to be filled in but is not used; it can be set to DUMMY, or some
other name of your choosing.
Since the IN Data Files specification is not used by the COBOL85 conversion program
it is not necessary to specify DEFINEs for the input files in the DEFINES or
PATHCNFG files.
IXF Data You must specify the IN Data Files field on the CONFIGURE (F1, Conversion
Environment) Screen even though it is ignored. You can set it to DUMMY or some
other name of your choosing. It is not used by the generated COBOL85 conversion
program but is used as a work file for the BUILD DDL (F2) step.
Since the IN Data Files specification is not used by the COBOL85 conversion program
it is not necessary to specify DEFINEs for the input files in the DEFINES or
PATHCNFG files.
Input Data From IBM
Data Sets/Tables
For a DB2 to NonStop SQL conversion, the best and easiest method is to provide input
data to Data Build in IXF format. For IXF input, Data Build essentially does
everything. It creates the Source Record Descriptions and the CREATE TABLE files
and it creates the actual NonStop SQL tables.
Creating IXF Data from DB2
Using QMF
IXF data can be created by the IBM QMF (Query Management Facility) and DXT (Data
Extract) products.
The following QMF command will produce IXF output data:
EXPORT TABLE tablename To dataset (DATAFORMAT=IXF OUTPUTMODE=CHARACTER
Note that the closing right parenthesis is not used.