Data Load Utility: dbload

4.5.1The DEFINE RECORD Statement

The DEFINE RECORD statement is used to define the record that is to be loaded into the data- base. It describes the data found in the data file. The following are the definitions that are made known by the DEFINE RECORD statement:

•Names the record to be loaded

•Names the fields of the record to be loaded as found in the data file

•Specifies whether the records in the data file are variable length records or fixed length records

•If fixed length records, specifies the position and data type of the field

The following is the syntax definition of the DEFINE RECORD statement:

DEFINE RECORD record_name

[ OF FIXED LENGTH record_length AS (

field_name position_specification type_specification, ...

)

]

AS (

field_name, ...

)

[ FIELD DELIMITER delimiter_char ]

[ RECORD DELIMITER delimiter_string ] ;

position_specification::

POSITION ( start_position : end_position )

type_specification::

CHAR

SHORT

LONG

FLOAT

DOUBLE

The following are the variable descriptions of the DEFINE RECORD syntax:

•record_name is the name used to refer to the records found in the data file.

•record_length is the length of the fixed length record. This length should include the length of field or record delimiters, if any.

•field_name is the name used to refer to a field in the data file.

•delimiter_char is the field delimiter and is a single character. It must be specified as a lit- eral.

•delimiter_string is the record delimiter and can be a single character or a string. It must be specified as a literal.

FairCom Corporation

4-5