Filter
Top Products
Data Load Utility: dbload
FairCom Corporation 4-5
4.5.1 The 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.