SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—544536-007
10-24
Summary of import Options
-U Specifies the name of the file that contains format specifications for the
input file. The format file must be an OSS or Guardian text file. The
Guardian file name must be specified in OSS format. The format file cannot
exceed 60,000 bytes.
The format file specified with -U cannot contain a circumflex (^) character
or a comma (,) and cannot contain a minus sign (-) as the first character of
the name.
-W Specifies the input file type. The possible values for the input file type are
DELIM and FIXED. If you do not specify this parameter, import assumes
the default DELIM file type (a delimited input file). If you do not specify this
parameter and there is no format file, import assumes the default
delimeters for a delimited input file.
-XE Specifies the pathname exec-error-filename of an OSS output file to
which import logs data rows that have execution errors. After the rows in
the error file are edited to resolve the execution errors, the resultant error
file can be used as an input file by a subsequent import execution.
The name of the error file must be specified in the OSS format, for example
/usr/jdoe/errfile, and must not be the same file as the one specified
with the -E error-filename option if the -E option is also specified. This
output file is created by the import utility as a non-audited, OSS
unstructured file (or a Guardian file of type 180 if the error log file is
specified to be under /G). If the file already exists, import terminates with
an error message.
-XL Directs import to ignore the specified number max-exec-errors (from
0 to 2147483646) of ignorable execution errors without terminating. If the
number of execution errors detected by import exceeds max-exec-
errors, import terminates. Because of internal bundling of multiple rows
for insertion, import may report several more than max-exec-errors
detected when it does terminate.
-XM Specifies the pathname exec-errormsg-filename of an OSS output file
to which import logs the error messages that correspond with the logged
data rows that have execution errors. The name of the error message file
must be specified in the OSS format, for example /usr/jdoe/errfile,
and may be the same as the one specified with the -XE option, but must
not be the same as any other output file.
This output file is created by the import utility as a non-audited, OSS
unstructured file (or a Guardian file of type 180 if the error log file is
specified to be under /G). If the file already exists, import terminates with
an error message.
-Z Specifies the character set of the data being imported. Valid values are
ISO88591 or UCS2.
Table 10-1. import Command Options (page 2 of 2)
import
Option Description