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

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—523723-004
10-23
Summary of import Options
Summary of import Options
Table 10-1 describes the most important import command options.
For more information about these and other import command options, see the
SQL/MX Reference Manual.
Table 10-1. import Command Options
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
and binary data to import.
-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.
For example, if -T is 500 and the failure occurs while import is loading
row 4991, rows 0 through 4500 are committed. However, rows 4501
through 4990 inserted before the failure at 4991 are rolled back. In this
scenario, you can restart import after fixing the problem in the input file by
issuing the command:
import cat1.schema1.t1 -I t1.txt -F 4501
where -F identifies the row where import should resume.
-U 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 2 GB.
-Z Specifies the character set of the data being imported. Valid values are
ISO88591 or UCS2.