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-46
import Utility
Regardless of whether parsing-errormsg-filename and error-filename
are the same file, if you invoke import again, with error-filename as the input
file, the same format file can be used. Any interspersed error messages are
automatically ignored by import. You must specify the same file type (DELIM or
FIXED) when using error-filename, as was used for the original input file.
-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).
-SF summary-filename
specifies the name summary-filename of a non-audited, OSS unstructured file
(or Guardian file of type 180 if the filename is under /G) to which import writes
the number of input rows read so far, the number of input rows that were skipped
(either due to the use of the -F <first-row> option or because they were comment
lines), the elapsed time since starting to read the first input row, and the elapsed
time since skipping the initial rows specified via the -F <first-row> option. These
four lines are repeated af
ter every summary-interval number of rows have been
read from the input file. Additional information is appended to the results summary
Note. If -PM option is specified, you must also consider the space consumed by the error
message log file when choosing the -L value. Each error message will take at least 80
bytes or more if the error message includes specified column data, and so on.