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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-31
import Utility
-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 after every summary-interval number of rows have been
read from the input file. Additional information is appended to the results summary
file at the completion of the import operation (see Support for restarting import on
page 5-57).
The results summary file is created by the import utility. If it already exists or if
the specified filename is the same as for any error output file, import terminates
Note. If the -PM option is used, 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 and may be much longer if the error message includes specified column data,and so
on.