SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-22
LOAD Command

For entry-sequenced files or tables, record-spec is the Enscribe record
address. For descriptions about the record addresses in entry-sequenced files
and tables, see the Enscribe Programmer's Guide.
KEY ( key-value> [, key-value ] ... )
indicates the approximate position of the starting record for key-sequenced files.
Subsequent rows are obtained in primary key order. key-value is either a string
in quotation marks or an integer in the range 0 to 255. (Each integer represents the
value of 1 byte.)
For more information about specifying a FIRST KEY value, see Considerations—
LOAD on page L-33.
key-specifier ALTKEY ( key-value [, key-value ]...)
indicates the approximate position within the specified alternate key file of the
starting record for key-sequenced files. Subsequent rows are obtained in alternate
key order.
key-specifier is a one-character or two-character string in quotation marks, or
a numeric literal in the range 0 through 32,767 that designates the alternate key to
use for the positioning.
Specify key-value for key-sequenced files according to the description of
key-value in the preceding KEY (key-value) option and under
Considerations—LOAD on page L-33.
PAD pad-character
(for loading non-SQL objects only) pads output records containing less than
in-record-length bytes with the pad-character up to the record length
specified in the file label of the output file. Specify pad-character as a single
ASCII character inside quotation marks (“c”) or as a numeric literal in the range of
0 through 255 representing the byte value of the character.
REPLACE SPACES WITH { ZERO[ES] | DEFAULT[S] }
specifies how to load an Enscribe ASCII numeric decimal field that contains all
blanks into an SQL numeric column. ZEROES specifies that the target column
should be set to zero; DEFAULTS specifies that the target column should be set to
its default value. This option does not apply to Enscribe numeric binary fields.
If you do not specify this option for an Enscribe ASCII numeric decimal field, a
conversion error occurs for any record in which the field contains blanks.
UNSTRUCTURED
(for loading from a table or disk file only) directs LOAD to handle the data as a
sequence of bytes, ignoring any record structures normally recognized for the table
or file. This option is typically used with the COPY command to let you examine