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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-22
import Utility
To import data to the table mycat.mysch."%&*()", you must specify the
delimited table name within the import command:
import 'mycat.mysch."%&*()"' -I myinput.dat
The delimited name is enclosed within a pair of double quotes (") and the fully
qualified name of the destination table and the data are enclosed in single quotes
(‘).
-I input-filename
specifies the name of the input file that contains the data to import.
input-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.
input-filename must not contain a minus sign (-) as the first character of the
name.
-C num-rows
is the number of rows (or records) to import. import terminates when num-rows
input rows have been imported or when it reaches the end of the input file. If you
do not specify this parameter, import imports all rows.
-D
disables all triggers before the actual insert operation starts and enables the
disabled triggers after the import operation is complete.
-E error-filename
specifies the name of the log file for rows in error.
error-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/error.txt or /G/USER/DATA/ERROR.
error-filename must not contain a minus sign (-) as the first character of the
name.
-F first-row
is the number of the first row (or record) to import. The first row of the input file is
designated as the number 0. If you do not specify this number, import begins with
the first row (which is the same as specifying -F 0).
-FD field-delimiter
specifies the single or multicharacter field delimiter for the file. The default delimiter
is a comma (,). This parameter takes precedence over the field delimiter specified
in a format file. To specify a space as a field delimiter, use " " or ' '. If you