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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-27
import Utility
import Utility
Considerations for import
Parallel Load for import
Programmatic Interfaces
Output File Consideration
Examples of import
The import utility imports data from an input file in ASCII or UCS2 format into an
SQL/MX table. This utility supports OSS large files (files greater than 2 GB) as input
files.
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:
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
| -LES
| -PM parsing-errormsg-filename
| -QL field-qualifier
| -RD row-delimiter
| -SF summary-filename
| -SI summary-interval
| -T transaction-size
| -U format-filename
| -W file-type
| -XE exec-error-filename
| -XL max-exec-errors
| -XM exec-errormsg-filename
| -Z charset
sh import catalog.schema.table -I input-filename
[import-option]... ;