Data Build Manual

1 Introduction to Data Build

099331 Tandem Computers Incorporated 1–1

You use Tandem Data Build to convert data from a non-Tandem system and to load

the converted data into a Tandem file. Data Build also loads data from a flat file or a

Tandem Enscribe file to a NonStop SQL table. Data Build provides a significant

performance enhancement to the standard SQL load process.

Data Build creates a COBOL85 conversion program that reads files containing the

input data and loads the data to Tandem files. Figure 1-1 shows the major inputs to

Data Build (source record descriptions and file naming conventions) and the major

outputs of Data Build (conversion procedures, Data Definition Language (DDL), and

COBOL85 conversion program). After Data Build creates the COBOL85 conversion

program, you use a Data Build function key (F5) to run the COBOL85 conversion

program which converts and loads the input data into Tandem files.

Figure 1-1. Data Build Overview

002

Name the Files

Xxxx xx xxx

Source Record

Descriptions

NS SQL

Table(s) or

Enscribe

File(s)

Data Conversion

Facility

F1 CONFIGURE. . .

F2 BUILD. . .

F3 GENERATE. . .

F4 CREATE. . .

F5 RUN. . .

Conversion

Procedures

DDL

Input Data

COBOL85

Conversion

Program

Load/Insert

Write

You must provide Data Build with a Source Record Descriptions file for every input

file you want converted. This file defines the structure of the input data record,

specifying the length and data type of each field in the input record.

Note For one type of input, Data Build automatically creates the Source Record Descriptions file. If your data is

in Integration Exchange Format (IXF), you do not need to create a Source Record Descriptions file. Don’t

confuse the abbreviation IXF used throughout this manual with the Tandem file transfer utility called IXF.