Data Build Manual

Configuring the Conversion Environment (F1)
Running Data Build
4–10 099331 Tandem Computers Incorporated
Table 4-2. OPTIONS Field Settings
Option Number Setting Description
1 blank
ENSCRIBE
Creates an Enscribe conversion program.
1 SQL-INSERT Creates a NonStop SQL database conversion program for
inserting records into NonStop SQL tables. Data Build
automatically sets the defaults for the database. See the
subsection “Changing the NonStop SQL Defaults” later in this
section or more information.
1 SQL-LOAD Creates a NonStop SQL database conversion program that
loads records to a NonStop SQL database. See the
subsection “Changing the NonStop SQL Defaults” for more
information.
2 Blank Specifies that the input data is not sorted. Option 2 applies
only if option 1 is SQL-LOAD.
2 SORTED Specifies that the input data is already sorted for loading to a
NonStop SQL table. This setting can only be used with SQL-
LOAD. If Option 2 is specified as SORTED, the SQLCI LOAD
commands in the file ZZLOAD will contain a SORTED option.
3 Blank Specifies IBM EBCDIC input data, not in IXF format.
3 IXF Specifies IXF for the input format. If you have IXF data, you
do not need to create source record descriptions for the input
files.
3 ASCII Specifies that all character input data is in ASCII format. If this
is not specified, all character data is assumed to be in
EBCDIC.
4 Blank Specifies that the input is on disk and not CSV format.
4 =TAPE Specifies tape for the input media. If this is not specified,
Data Build assumes that the data input files are on disk.
4 CSV=* Specifies the input data is in comma-separated values format.
The asterisk is a user-selectable delimiter character, usually
set to a comma (CSV=,).
5 Blank For SQL-INSERT or SQL-LOAD, specifies that the conversion
program will stop if an error is detected.
5 ALLOWnnnnn Specifies for SQL-INSERT or SQL-LOAD the number of errors
allowed before the program stops. nnnnn represents numeric
digits, all of which you must enter. For example, to allow five
errors, enter ALLOW00005.
6 Not used Blank