SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-117
COPY Command
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 copying from a table or disk file only) directs COPY to handle the data as a
sequence of bytes, ignoring any record structures normally recognized for the table
or file. The UNSTRUCTURED option lets you examine only the one partition
named as the source file in the command.
UPSHIFT
(for copying to an Enscribe file only) converts all bytes of the input that contain
lowercase ASCII characters to uppercase ASCII characters before copying 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 copying from Enscribe files to SQL tables only) specifies that a null value from
an Enscribe file be copied as an SQL null value.
USESQLNULLS applies only if the SQL column being copied to 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 handled as null.)
If you omit USESQLNULLS, COPY 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 COPY 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, COPY 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, COPY does not support null indicators for
Enscribe fields. SQLNULLABLE does not affect loading from SQL tables to SQL