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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-21
import Utility
If you want 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 is 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.
-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.
-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
specify both a field-delimiter and a row-delimiter, they cannot be the same
character.
If you are running import from the MXCI command prompt and are using special
characters as field delimiters, you must enclose special characters in single or
double quotes (for example, '|*|').
If you are running import from the OSS command prompt and are using special
characters as field delimiters, you must use the escape character "\" before special
characters.
-H
displays helpful information about import command-line options.