SQL/MX 2.x Installation and Management Guide (H06.04+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—540436-001
10-22
Using import to Load SQL/MX Tables
Example of Moving an Entire System-Clustered Partition to a New
Location
You suddenly need to use $DATA09 for other purposes. You decide to move the
system-clustered table ORDERSSC to a different volume. Use this MODIFY TABLE
command to move the table to the volume $DATA03:
MODIFY TABLE cat4.sch4.orderssc move partition
to location $DATA03;
Using import to Load SQL/MX Tables
Use the import command to move data from an input file in ASCII or UCS2 format
into an existing SQL/MX table. For example, you would use import to load an input
file that contains the ASCII-formatted contents of another vendor’s SQL table into an
SQL/MX table. DataLoader/MX can also send output to an import process.
Guidelines for Using import
•
The input data file and the table must already exist before you can import the data
into table. import does not create the files or tables.
•
import adds data to a table without purging existing data.
•
Whenever possible, import automatically loads data into an empty table by using
a special fast loading technique designed specifically for NonStop SQL/MX.
•
import automatically loads dependent indexes while loading the table rows.
Performance considerations for loading dependent indexes are described in
Managing Indexes to Improve import Performance on page 10-28.
•
import automatically performs constraint validations while loading table rows.
Performance considerations constraint validation are described in Managing
Constraints to Improve import Performance on page 10-27.
•
import automatically performs triggered actions while loading table rows.
Performance considerations for performing triggered actions are described in
Managing Triggers to Improve import Performance on page 10-28.
Summary of import Options
Table 10-1 describes the most important import command options.
Note. The ability of the import utility to accept binary input files has been explicitly disabled
for SQL/MX Release 2.x.