Data Build Manual

Sample Data Conversion to Enscribe
Running the Sample Programs
5–2 099331 Tandem Computers Incorporated
DEMO01, the COBOL85 group level record definition, is used as a logical record name
in the Enscribe conversion program. The field names at the 02 level tell Data Build the
field’s data format in the source system input file.
The DEFINES File The next file you need to look at is the DEFINES file, which contains TACL DEFINEs.
The DEFINEs in this file give Data Build information about the conversion process
before the process starts. For example, it tells Data Build the volume and subvolume
names for each input and output file in the conversion.
To look at the DEFINES file, do the following:
1. Make sure you are at the conversion project subvolume.
2. Use the editor to look at the DEFINES file.
The following example shows the default DEFINES file copied by the Project utility,
which is set up for the Data Build sample conversions.
SET DEFMODE ON
DELETE DEFINE =CAT
ADD DEFINE =CAT,CLASS CATALOG,SUBVOL $DATA01.KOD2016S
ALTER DEFINE =_DEFAULTS,CATALOG $DATA01.KOD2016S
DELETE DEFINE =TBLSRC
ADD DEFINE =TBLSRC, CLASS MAP, FILE $DATA01.KOD2016.TBLSRC
DELETE DEFINE =DATAIN01
ADD DEFINE =DATAIN01, CLASS MAP, FILE $DATA01.KOD2016.DATAIN01
DELETE DEFINE =DATAIN02
ADD DEFINE =DATAIN02, CLASS MAP, FILE $DATA01.KOD2016.DATAIN02
DELETE DEFINE =DATAIN03
ADD DEFINE =DATAIN03, CLASS MAP, FILE $DATA01.KOD2016.DATAIN03
DELETE DEFINE =DATAOT01
ADD DEFINE =DATAOT01, CLASS MAP, FILE $DATA01.KOD2016.DATAOT01
DELETE DEFINE =DATAOT02
ADD DEFINE =DATAOT02, CLASS MAP, FILE $DATA01.KOD2016.DATAOT02
DELETE DEFINE =DATAOT03
ADD DEFINE =DATAOT03, CLASS MAP, FILE $DATA01.KOD2016.DATAOT03
DELETE DEFINE =DEMO01
ADD DEFINE =DEMO01, CLASS MAP, FILE $DATA01.KOD2016S.DEMO01
DELETE DEFINE =DEMO02
ADD DEFINE =DEMO02, CLASS MAP, FILE $DATA01.KOD2016S.DEMO02
DELETE DEFINE =DEMO03
ADD DEFINE =DEMO03, CLASS MAP, FILE $DATA01.KOD2016S.DEMO03
DELETE DEFINE =SQLMSGS
ADD DEFINE =SQLMSGS, CLASS MAP, FILE $DATA01.KOD2016.SQLMSGS
DELETE DEFINE =TAPE
ADD DEFINE =TAPE,CLASS TAPE,LABELS BYPASS,DEVICE \D00.$TAPE
The ADD DEFINE for =CAT shows the location of the NonStop SQL catalog. The
three ADD DEFINEs for DEMOnn show the names and locations of the NonStop SQL
tables. These DEFINEs are used for the sample SQL-INSERT and SQL-LOAD
conversions, and are not used in the Enscribe sample conversion.