Data Build Manual

Source Record Descriptions File
Setting Up the Project Environment
3–12 099331 Tandem Computers Incorporated
To create the source record descriptions:
1. Execute the SQLCI INVOKE command for each table to produce a Source Record
Descriptions file.
SQLCI INVOKE tablename FORMAT COBOL85 TO filename CLEAR
where tablename is the SQL table just created, and filename is its associated Source
Record Descriptions file.
SQLCI supplies the following except for the DATE and TIME, which were added
by editing the file:
01 DEMO03.
02 DEM3-DATE PIC X(10) DATE.
02 DEM3-TIME PIC X(8) TIME.
02 DEM3-NUMBER PIC S9(4) COMP.
02 DEM3-DESCR PIC X(9).
02 DEM3-TYPE PIC S9(4) COMP.
02 DEM3-VENDORID PIC S9(4) COMP.
02 DEM3-WHLSLRID PIC S9(4) COMP.
02 DEM3-PARTNO PIC S9(4) COMP.
02 DEM3-PRICE PIC S9(9) COMP.
02 DEM3-CODE PIC X(2).
02 DEM3-COST PIC S(9) COMP.
2. Edit this, if necessary, to create a Source Record Descriptions file. Note the
following:
DEMO03, the COBOL85 group level record definition, corresponds to the
output table DEFINE name.
The data types at a higher level number (such as the 02 level) tell Data Build
the field’s data format in the input file.
Using the information in Table 3-2, edit the file so that it has valid choices. For
example, you might add options, such as COMP-3 and DATE. In the above
example, DATE and TIME were added.
Naming and Copying the Files
Each Source Record Descriptions file name starts with a 1 to 6 character prefix,
followed by a consecutively numbered two-digit suffix. The two-digit suffix must
match the suffix of the corresponding input file. For example, the Source Record
Descriptions file names might be DB2DEF if the input files were DB2. Then each file
would have a numeric suffix, such as DB2DEF01, DB2DEF02, and DB2DEF03. See
Section 2 for detailed information on file naming.
Copy the Source Record Descriptions files to the conversion project subvolume after
they are prepared.