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-30
Examples of Using import to Load an SQL/MX Table
You might specify the three import commands as follows:
/usr/bin:import corpcat.persnl.employee -I empfile -C 3000 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile -C 2000 -F 3000 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile -C 2000 -F 5000 -T 500
The count of the number of records for each partition must be less than or equal to
the space available in each partition, and the rows to be imported into each
partition must have an appropriate clustering key. In the preceding example, the
first partition permits employee numbers ranging from 0 to 2999.
•
Run multiple instances of the import command—one for each partition in the
destination table—to load data into a partitioned table by using a separate input file
for each partition. Each of the input files contains the data for each partition.
For example, you might specify the three import commands for the partitioned
EMPLOYEE table as:
/usr/bin:import corpcat.persnl.employee -I empfile1 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile2 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile3 -T 500
Examples of Using import to Load an SQL/MX Table
Example 1: Importing Data From a Delimited File
This example is of an import of data from a delimited file. It shows the structure of the
table to be loaded, the data to be loaded (the input data file), the format file describing
the data, and the import command used to load it.
Table Structure
This statement creates the target table, COMPANY:
CREATE TABLE company
( id INT NOT NULL
,company VARCHAR (176)
,phone VARCHAR (12)
,fax VARCHAR (12)
,PRIMARY KEY (id)
);
Data to Input
The input file, COINPUT, contains records like this:
1,"Test String 1","111-222-3333","222-333-4444"
2,"Test String 2","111-222-3333","222-333-4444"
3,"Test String 3","111-222-3333","222-333-4444"
4,"Test String 4","111-222-3333","222-333-4444"
5,"Test String 5","111-222-3333","222-333-4444"
6,"Test String 6","111-222-3333","222-333-4444"
Note. Check that the ranges specified are exact. For example, check that there are no
gaps or omissions and no overlap of rows.