Data Build Manual

Modifying the DEFINES and PATHCNFG Files
Setting Up the Project Environment
3–14 099331 Tandem Computers Incorporated
NonStop SQL Conversion For a NonStop SQL conversion, the DEFINES file must have a DEFINE for each input
file and output table, and the NonStop SQL catalog. The following DEFINEs specify
two input files VSAMIN01 and VSAMIN02. Separate DEFINEs name the two
NonStop SQL tables STATE and RATETB. The following is an example from a
DEFINES file:
SET DEFMODE ON
DELETE DEFINE =CAT
ADD DEFINE =CAT,CLASS CATALOG,SUBVOL $CONVERT.SQLCAT
ALTER DEFINE =_DEFAULTS,CATALOG $CONVERT.SQLCAT
DELETE DEFINE =TBLSRC
ADD DEFINE =TBLSRC, CLASS MAP, FILE $CONVERT.SUBVOL.TBLSRC
DELETE DEFINE =VSAMIN01 <-- Input File
ADD DEFINE =VSAMIN01, CLASS MAP, FILE $CONVERT.SUBVOL.VSAMIN01
DELETE DEFINE =VSAMIN02
ADD DEFINE =VSAMIN02, CLASS MAP, FILE $CONVERT.SUBVOL.VSAMIN02
DELETE DEFINE =STATE <-- SQL Table
ADD DEFINE =STATE, CLASS MAP, FILE $CONVERT.SQLCAT.STATE
DELETE DEFINE =RATETB
ADD DEFINE =RATETB, CLASS MAP, FILE $CONVERT.SQLCAT.RATETB
Now that you have changed the DEFINES file, you can easily make the same changes
to the PATHCNFG file. Copy each ADD DEFINE statement (which you added to the
DEFINES file) to the PATHCNFG file and change the “ADD” to “SET SERVER.” The
following is an example from a PATHCNFG:
RESET SERVER
SET SERVER DEFINE =VSAMIN01, CLASS MAP, FILE $CONVERT.SUBVOL.VSAMIN01
SET SERVER DEFINE =VSAMIN02, CLASS MAP, FILE $CONVERT.SUBVOL.VSAMIN02
SET SERVER DEFINE =STATE, CLASS MAP, FILE $CONVERT.SQLCAT.STATE
SET SERVER DEFINE =RATETB, CLASS MAP, FILE $CONVERT.SQLCAT.RATETB
SET SERVER DEFINE =CAT,CLASS CATALOG,SUBVOL $CONVERT.SQLCAT
SET SERVER PROGRAM $INSTALL.SUBVOL.RUNSRVR
SET SERVER CPUS (1:0)
SET SERVER MAXSERVERS 2
SET SERVER MAXLINKS 5
ADD SERVER RUN-PROC-DCNVT