SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-50
import Utility
If the -Z option is used to specify that the input file contains characters other than
ISO88591, and exec-errormsg-filename and exec-error-filename are
specified to be the same file, Import will terminate with an error message.
(Displaying or editing a file with characters from more than one character set would
be very difficult, if not impossible.)
If exec-errormsg-filename and exec-error-filename are not the same
file, the error messages in the error message file will be in the same order as the
corresponding logged rows in error in the error file. This should be sufficient to
allow the user to determine the corresponding error message for any particular row
in exec-error-filename.
The error messages written to exec-errormsg-filename will not have any row
number in them to indicate the row in the input file or in exec-error-filename
associated with the error message.
Regardless of whether exec-errormsg-filename and exec-error-
filename are the same file, if you invoke import again with exec-error-
filename as the input file, the same format file can be used. Any interspersed
error messages will be automatically ignored by import. You must specify the
same file type (DELIM or FIXED) when using exec-error-filename as was
used for the original input file.
It is important to note that Dataloader/MX has a pass-through mode where the
input data is sent on as the output data without performing any transformations on
the data. That capability should allow an error log file produced by import (with or
without interspersed error message strings) to be used as the input file for
Dataloader/MX, if desired.
-Z charset
specifies the character set for the data being imported. Valid values are ISO88591
or UCS2. The default value for -Z option is ISO88591. For details about character
set conversion, see Data Types of Input Values for Input File
on page 5-58.
Note. If the -XM option is used, you should also consider the space consumed by the
error message log file when choosing the -XL value. Each error message will take at least
65 bytes and may be much longer if the error message includes a specified table name,
check condition name, and so on. If exec-errormsg-filename and exec-error-
filename are the same file, the error messages also have the indicator prefix and suffix
strings and with both the error messages and the rows in error going into the same file, an
even smaller -XL value may be appropriate.