SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-22
import Utility
-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.
-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).
-T transaction-size
specifies the number of records processed before a commit. If import returns an
error before the record count reaches transaction-size, the changes to the
database within that transaction are rolled back. The number of imported rows is
the number successfully committed.
You might want to set the -T option to less than 500 to avoid lock escalation. If you
do not specify this parameter the default transaction-size is 10,000 records.
If the table is empty, import turns off the audit attribute on the table before
inserting rows, to perform fast load for better performance. In this case, the -T
option has no effect as the table is unaudited during the import operation.