NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-35
Considerations—LOAD
blanks must be acceptable in that column of the source record. For example, a
decimal field would not accept blanks; a character field would.
•
If the record contains an array defined by an OCCURS DEPENDING ON
clause and at least one element of the array is present, then the field that
contains the count must be present and the number of elements in the record
must be equal to the value of the field that contains the count.
•
If the input records must be sorted, then disk space for the sort scratch file and
for the output file must exist concurrently during the sorting phase.
•
Move options
Move options associate source fields and target fields so that data is transferred from
each source field to its corresponding target field. Some considerations for using
move options follow:
°
If you move data from a table to a table or between an Enscribe file and a table
and you do not specify MOVE, MOVEBYNAME, or MOVEBYORDER, SQL
uses MOVEBYORDER.
°
If you do not specify a DDL record definition for a move between an Enscribe
file and an SQL table, SQL constructs a DDL record definition for the Enscribe
file based on the description of the SQL table.
The record description assumes that corresponding fields are in the same order
in both the file and the table. The correspondence between data types is the
same as that described under CONVERT with the following exceptions:
See the Data type compatibility and field conversions item later in this
subsection for more detail about these exceptions.
°
You cannot specify any move options when both source and target are Enscribe
files.
•
Field formats
If an Enscribe file is the source or target, LOAD loads only those fields whose DDL
definitions conform to the following rules:
°
The field must be elementary, unless it is the special DDL group that represents
a variable-length character string, in which case the field is treated as one field
during the LOAD operation. This DDL group has the following structure and is
converted to a column with data type VARCHAR:
02 A-VARCHAR
03 LEN PIC S9(4) COMP.
03 VAL PIC X(len).
SQL DDL
DECIMAL SIGNED DECIMAL, LEADING SIGN SEPARATE
TIMESTAMP BINARY 64
INTERVAL BINARY 16, 32, or 64