NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-22
LOAD Command
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-31.
PAD pad-character
(for loading Enscribe files 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 treat 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
raw data on disc. You do not need to request the UNSTRUCTURED option to
examine an unstructured file.
UPSHIFT
(for loading an Enscribe file only) converts all bytes of the input that contain
lowercase ASCII characters to uppercase ASCII characters before loading the data
to the target record.
The UPSHIFT conversion is made without regard to the data types of fields or
columns of the input, so undesired changes to the data can occur if you use
UPSHIFT with input that is not composed of simple character data.
Though you cannot specify the UPSHIFT option if out-file is an SQL table, data
moved to an SQL column that has the UPSHIFT attribute is automatically upshifted.
USESQLNULLS
(for loading from Enscribe files to SQL tables only) specifies that a null value from
an Enscribe file be loaded as an SQL null value.
USESQLNULLS applies only if the SQL column being loaded allows null values, if
you also specify the SOURCEREC option, and if the Enscribe null value appears in
every byte of the Enscribe field. (Enscribe allows you to specify a character to use
as the null character for a field at file-creation time, then uses that character to
represent null values within the field. Any field that is filled entirely with the null
character is treated as null.)