Data Build Manual

Source Record Descriptions File
Setting Up the Project Environment
099331 Tandem Computers Incorporated 3–11
Creating a Source Record
Descriptions File
You use EDIT or TEDIT to create a Tandem EDIT file for the Source Record
Descriptions. To prepare source record descriptions, you can use:
Existing COBOL record definitions from a non-Tandem system, modify those
definitions, and use the editor to create a Source Record Descriptions file .
SQLCI to create source record descriptions for data from an SQL database (such as
DB2 on IBM).
The Tandem editor to create the file from scratch.
Using Existing COBOL Record Definitions
The record descriptions for an input file may be in existing COBOL programs or copy
libraries on the source system. Copy the file from the source system or use the
Tandem editor to manually enter the record descriptions into a Tandem EDIT file.
If the source record descriptions are stored in COBOL copy libraries, you might have
to change certain standard COBOL constructs. For example, the VALUE or SIGN
clauses are not valid in the Source Record Descriptions file and must be removed.
Data Build does not handle some signed numeric display fields. If your data includes
unsupported data types, the input field should be specified as a character display,
PIC X(n), and you should provide code in a user exit to convert the data. Use the
information in Table 3-2 to edit the file to include valid choices.
Using SQLCI to Create NonStop SQL Tables and Source Record Descriptions
For a conversion to NonStop SQL, you should create the NonStop SQL tables before
creating the Source Record Descriptions file. You can do this by editing a file with an
SQL CREATE TABLE statement for each table. If the source data is DB2, the Tandem
CREATE TABLE statements are similar and can be a modified copy of the DB2
CREATE TABLE specification. An example of such a file is TBLSRC, which comes
with the Data Build samples.
Create the NonStop SQL tables after running the Project utility and before starting
Data Build.
To create the tables:
1. Run SQLCI from the TACL prompt by entering the following:
SQLCI /IN filename , OUT $S.# sqlout /
Where filename is the EDIT file containing the CREATE TABLE statement.
2. Check the spooler and correct any errors.