SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-29
import Utility
-F first-row
is the number of the first row (or record) to import. The first row of the input file is
designated as the number 0. If you do not specify this number, import begins with
the first row (which is the same as specifying -F 0).
-FD field-delimiter
specifies the single or multicharacter field delimiter for the file. The default delimiter
is a comma (,). This parameter takes precedence over the field delimiter specified
in a format file. To specify a space as a field delimiter, use " " or ' '. If you
specify both a field-delimiter and a row-delimiter, they cannot be the same
character.
If you are running import from the MXCI command prompt and are using special
characters as field delimiters, you must enclose special characters in single or
double quotes (for example, '|*|').
If you are running import from the OSS command prompt and are using special
characters as field delimiters, you must use the escape character "\" before special
characters.
-H
displays helpful information about import command-line options.
-IP proc-name
directs import to accept data from a DataLoader process, proc-name.
-L max-errors
directs import to ignore the specified number of parsing errors without
terminating. Executor errors due to constraint violation are not included in this
count. Valid values are 0 through 2147483647.
-LES
is an option to log errors. This option lets you ignore some parsing and execution
errors. It also allows the error log filenames and error message log filenames to be
automatically generated, instead of specifying values for the new -XL, -XE, -XM, -
PM, and -SF options, and the existing -L and -E options. The -LES option
changes the default values for the -L and -XL options to be 1000 each and the
default value for the -SF option to be Stdout (For description of the -SF option, see
section 5.1.2.). Using -LES changes the default values for the -E, -XE, -PM, and
-XM options to filenames, which import automatically chooses as unique files in
the current directory. Unless the -Z option is used to specify that the input file
contains non-ISO88591 characters, import will choose the filenames for the -PM
and -XM options similar to the -E and -XE options, respectively, thus intermixing
the error messages with the associated rows in error.