SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-23
LOAD Command
raw data on disc. You do not need to request the UNSTRUCTURED option to
examine an unstructured file.
UPSHIFT
(for loading a non-SQL object 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.
Although 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 non-SQL objects to SQL tables only) specifies that a null value
from a non-SQL object 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, and then uses that character to
represent null values within the field. Any field that is filled entirely with the null
character is handled as null.)
If you omit USESQLNULLS, LOAD provides no special treatment for Enscribe null
characters.
SQLNULLABLE
specifies that the support for null indicator values for Enscribe fields is enabled
when loading data from Enscribe to SQL or from SQL to Enscribe.
The SQLNULLABLE option causes LOAD to look for the SQLNULLABLE DDL
clause in the TARGETREC or SOURCEREC option, and depending on this clause,
add or read a two-byte null indicator for the Enscribe field value. Without
TARGETREC and SOURCEREC options, LOAD adds or reads the null indicator
for all Enscribe fields that correspond to a nullable column in the SQL table.
If you omit the SQLNULLABLE clause, LOAD does not support null indicators for
Enscribe fields. SQLNULLABLE does not affect loading from SQL tables to SQL
tables and Enscribe files to Enscribe files. The SQLNULLABLE option for Enscribe
to SQL loading automatically enables the USESQLNULLS option.
in-option
specifies characteristics of the input file.