SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Table 14 import Command Options (continued)
Descriptionimport Option
errors. The name of the error message file must be specified in OSS format, for example
/usr/jdoe/errfile, may be the same as the one specified with the -E option, but must
not be the same as any other output file.
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
-SF
so far, the number of those 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.
Specifies the number of rows (1 to 2147483647) that import must read from the input file
between updates of the information written to the summary file. If this option is not specified,
-SI
the default shall be to write the results summary information only at the completion of the import
operation.
Specifies the number of records to process before a commit. If import returns an error before
the record count reaches the number specified with this option, all changes to the database
-T
within that transaction are rolled back. If the error occurs after the record count has surpassed
the number of records specified, all rows up to failure, minus the -T option value, are rolled
back in the table.
Specifies the name of the file that contains format specifications for the input file. The format file
must be an OSS or Guardian text file. The Guardian file name must be specified in OSS format.
The format file cannot exceed 60,000 bytes.
nl
-U
The format file specified with -U cannot contain a circumflex (^) character or a comma (,) and
cannot contain a minus sign (-) as the first character of the name.
Specifies the input file type. The possible values for the input file type are DELIM and FIXED. If
you do not specify this parameter, import assumes the default DELIM file type (a delimited
-W
input file). If you do not specify this parameter and there is no format file, import assumes the
default delimiters for a delimited input file.
Specifies the pathname exec-error-filename of an OSS output file to which import logs
data rows that have execution errors. After the rows in the error file are edited to resolve the
-XE
execution errors, the resultant error file can be used as an input file by a subsequent import
execution.
nl
The name of the error file must be specified in the OSS format, for example
/usr/jdoe/errfile, and must not be the same file as the one specified with the -E
error-filename option if the -E option is also specified. This output file is created by the import
utility as a non-audited, OSS unstructured file (or a Guardian file of type 180 if the error log
file is specified to be under /G). If the file already exists, import terminates with an error
message.
Directs import to ignore the specified number max-exec-errors (from 0 to 2147483646)
of ignorable execution errors without terminating. If the number of execution errors detected by
-XL
import exceeds max-execerrors, import terminates. Because of internal bundling of
multiple rows for insertion, import may report several more than max-exec-errors detected
when it does terminate.
Specifies the pathname exec-errormsg-filename of an OSS output file to which import
logs the error messages that correspond with the logged data rows that have execution errors.
-XM
The name of the error message file must be specified in the OSS format, for example
/usr/jdoe/errfile , and may be the same as the one specified with the -XE option, but
must not be the same as any other output file.
nl
This output file is created by the import utility as a non-audited, OSS unstructured file (or a
Guardian file of type 180 if the error log file is specified to be under /G). If the file already
exists, import terminates with an error message.
Specifies the character set of the data being imported. Valid values are ISO88591 or UCS2.-Z
For more information, see the SQL/MX Reference Manual.
Using import to Load SQL/MX Tables 195