SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-23
import Utility
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.
-QL field-qualifier
specifies a single character field qualifier. The default qualifier is double quote (").
This parameter takes precedence over the field qualifier specified in a format file.
If you are running import from an MXCI command prompt and are using special
characters as field qualifiers, you must enclose special characters in single or
double quotes.
If you are running import from an OSS command prompt and are using special
characters as field qualifiers, you must use the escape character "\" before special
characters.
-RD row-delimiter
specifies the row delimiter row-delimiter. The default is the end-of-line
character (\n). This parameter takes precedence over the row delimiter specified in
a format file. If you specify both a field-delimiter and a row-delimiter, they cannot be
the same character.
If you are running import from an MXCI command prompt and are using special
characters as field qualifiers, you must enclose special characters in single or
double quotes (for example: '\r\n').
If you are running import from an OSS command prompt and are using special
characters as row delimiters, you must use the escape character "\" before special
characters (for example: \\r\\n).