SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-35
Examples of import
You might specify the three import commands as:
C:\>import corpcat.persnl.employee -I empfile -C 2999 -T 500
C:\>import corpcat.persnl.employee -I empfile -C 1999 -F 3000
-T 500
C:\>import corpcat.persnl.employee -I empfile -C 1999 -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 allows for employee numbers ranging from 0 to 2999.
•
Run multiple instances of the import utility—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:
C:\>import corpcat.persnl.employee -I empfile1 -T 500
C:\>import corpcat.persnl.employee -I empfile2 -T 500
C:\>import corpcat.persnl.employee -I empfile3 -T 500
Note. Check that the ranges specified are exact. (For example, no gaps or omissions and
no overlap of rows.)