SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—523723-004
10-22
Using import to Load and Append Input Data Into
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 and Append Input Data
Into SQL/MX Tables
Use the import command to move data from an input file in ASCII, UCS2, or binary
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.
•
import automatically loads data into an empty table by using a special fast load
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-27.
•
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.