SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-23
Considerations for import
-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/input.txt or /G/USER/DATA/INPUT).
-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.
-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 information about
character set conversion, see Data Types of Input Values for Input File on
page 5-29.
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 and you did not specify the -T option to define the
transaction size:
•
It is empty.
•
It has no indexes.
•
It has no droppable primary key, unique key, or foreign key constraints.
•
It has no enabled triggers or you specified the -D option to disable triggers.
To improve the performance of the fast load technique, import turns off the audit
attribute for the entire table at the start of the operation and turns it back on when the
operation ends. If another import operation is attempted on the same table while an
import operation with the fast load technique is being performed, the second operation
fails with a concurrent access error.
If you turn off auditing for the table, online dumps are invalidated. After the import
operation completes, you must perform a new TMF online dump for all partitions of the
table. When you specify the transaction size using the -T option, transactions are
enforced, and the audit attribute of the table is not altered even if the table meets the
rest of the criteria for using the fast loading technique.