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

Reorganizing SQL/MX Tables and Maintaining Data

HP NonStop SQL/MX Installation and Management Guide—544536-007

10-22

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-30.

•

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-29.

•

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-30.

Note. The ability of the import utility to accept binary input files has been explicitly disabled

for SQL/MX Release 2.x.