SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-43
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 in 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 is enclosed in single quotes (‘).
For object names containing single quote ('), use the escape character "\" before
special characters and quote. For example, to import data in table
cat.sch."t1'*&", use the import command:
import mycat.mysch.\"t1\'\*\&\" -I myinput.dat
-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.
For OSS text file, the newline (\n) character is the line break. For Guardian text file,
a carriage return followed by a newline (\r\n) is the line break. You must explicitly
mention the row delimiter for Guardian files. For example,
import table_name -i /G/USER/DATA/INPUT -RD '\r\n'
-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.