SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-24
Considerations for import
-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.
-W file-type
specifies the input file type. The possible values for file-type are DELIM and
FIXED. If you do not specify this parameter, import assumes the default DELIM
file type (a delimited 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.
If you use the -W option, it must follow the -IP option on the command line.
-Z charset
specifies the character set for the data being imported. Valid values are ISO88591
or UCS2. The default value for -Z option is ISO88591. For details about character
set conversion, see Data Types of Input Values for Input File on page 5-32.
Considerations for import
You must have ALL privileges on the destination table or be the super ID.
Fast Loading and Transaction Considerations
If you are importing into an empty table, import uses the fast-loading technique if the
target table meets these criteria:
•
It is empty.
•
It has no indexes.