SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-28
import Utility
import
must be lowercase.
catalog.schema.table
specifies the fully qualified name of the destination table for the imported data. You
must specify the catalog and schema names.
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.