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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-20
import Utility
import Utility
Considerations for import
Examples of import
The import utility imports data from an input file in ASCII or UCS2 format into an
SQL/MX table.
The import utility executes at the OSS or MXCI command prompt using the
command-line options described next. You cannot directly execute the import utility
from programs.
From an OSS command prompt:
From the MXCI command prompt:
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.
Note. You can use DataLoader/MX, in conjunction with import, to load and maintain SQL/MP
and SQL/MX databases. You must have INSERT privileges to use DataLoader/MX to load an
SQL/MX table. For more information, see the DataLoader/MX Reference Manual.
import catalog.schema.table -I input-filename
[import-option]...
import-option is:
| -C num-rows
| -D
| -E error-filename
| -F first-row
| -FD field-delimiter
| -H help
| -IP proc-name
| -L max-errors
| -T transaction-size
| -U format-filename
| -W file-type
| -QL field-qualifier
| -RD row-delimiter
| -Z charset
sh import catalog.schema.table -I input-filename
[import-option]... ;