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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-32
import Utility
with an appropriate error message. If the -SF option is not specified, the summary
information will not be generated.
If only -SF is specified (without file name), the results summary information is
written to Stdout at the completion of the import operation. Any positive value
specified for the -SI option is ignored because the process responsible for
updating the four lines of progress information cannot access Stdout for the
import process.
-SI summary-interval
specifies the number of rows (1 to 2147483647) that import has to read from the
input file between updates of the information written to the summary file. If this
option is not specified, the default configuration writes the results summary
information only at the completion of the import operation.
-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.
To perform fast load for better performance, import turns off the audit attribute on
the table before inserting rows. In this case, the -T option has no effect because
the table is unaudited during the import operation.
-U format-filename
specifies the name of an OSS or Guardian text file that contains format
specifications for input-filename. Using a format file is optional.
format-filename must be an OSS text file (an odd-unstructured file, type 180)
or a Guardian text file (type 101). You must specify the file name in OSS format (for
example: /usr/bin/format.txt or /G/USER/DATA/FORMAT).
format-filename must not contain a circumflex (^) character or a comma (,)
and must not contain a minus sign (-) as the first character of the name.
Note. It is important to remember that (for best performance reasons and to keep the
results summary file from growing very large) the value for summary-interval be at least
10000. The size of the results summary file will increase by approximately 130 bytes each
time the four lines of progress information is appended. Therefore, for example, if the input
file has 100,000,000 rows and summary-interval is chosen to be 10000, the results
summary file will be about 1.3MB in size.