SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

ordernumber integer unsigned not null not droppable,
ordertime timestamp)
location $DATA09;
Example of Moving an Entire System-Clustered Partition to a New Location
You 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” (page 200).
• import automatically performs constraint validations while loading table rows. Performance
considerations constraint validation are described in “Managing Constraints to Improve import
Performance” (page 199).
• import automatically performs triggered actions while loading table rows. Performance
considerations for performing triggered actions are described in “Managing Triggers to
Improve import Performance” (page 200).
Summary of import Options
Table 14 (page 194) describes the most important import command options.
Table 14 import Command Options
Descriptionimport Option
Disables all triggers before the data is inserted, which prevents trigger actions from occurring.-D
Specifies the first row and the number of rows to import from the input file. The first row is
designated 0 (zero). import terminates when the number of rows specified has been inserted
or when it reaches the end of the input file.
-F and -C
Specifies the name of the input file that contains the data to be imported. The input file must be
an OSS or Guardian text file. Guardian file names must be specified in OSS format (for example,
/G/DATA01/subvolume/file-name).
-I
Specifies the name of the DataLoader/MX process that can provide ASCII data to import.-IP
This option allows you to ignore some parsing and execution errors and to automatically generate
the error log filenames and error message log filenames.
-LES
Specifies the pathname parsing-errormsg-filename of an OSS output file to which
import logs the error messages that correspond with the logged data rows that have parsing
-PM
194 Reorganizing SQL/MX Tables and Maintaining Data