SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—544536-007
10-23
Summary of import Options
Summary of import Options
Table 10-1 describes the most important import command options.
Table 10-1. import Command Options (page 1 of 2)
import
Option Description
-D Disables all triggers before the data is inserted, which prevents trigger
actions from occurring.
-F and -C Specifies the first row and the number of rows to import from the input
file. The first row is designated 0 (zero). import terminates when the
number of rows specified has been inserted or when it reaches the end of
the input file.
-I Specifies the name of the input file that contains the data to be imported.
The input file must be an OSS or Guardian text file. Guardian file names
must be specified in OSS format (for example,
/G/DATA01/subvolume/file-name).
-IP Specifies the name of the DataLoader/MX process that can provide ASCII
data to import.
-LES This option allows you to ignore some parsing and execution errors and to
automatically generate the error log filenames and error message log
filenames.
-PM Specifies the pathname parsing-errormsg-filename of an OSS
output file to which import logs the error messages that correspond with
the logged data rows that have parsing 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.
-SF 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 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.
-SI 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, the default shall be to write the
results summary information only at the completion of the import
operation.
-T 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 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.