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-38
Using import to Append Data to Tables or Partitions
Elapsed time = 0:0:0.088011
Elapsed time since skipping initial rows = 0:0:0.088011
Rows Imported Successfully = 4
Rows ignored due to parsing errors = 4
Rows ignored due to execution errors = 2
Parsing Error Log File Name: X.perrs
Parsing Error Messages File Name: X.perrmsg
Execution Error Log File Name: X.xerrs
Execution Error Messages File Name: X.xerrmsg
Import Completed with some non-fatal errors
Using import to Append Data to Tables or Partitions
Use the import command to append data to the end of a table or partition of an
SQL/MX table.
The import command preserves the existing data in the target table.
When you use the import command in an DSS environment, you can keep a data
warehouse up to date by performing periodic (for example, daily, weekly, or monthly)
updates to the database.
Use the import command to append data to multiple partitions of a table. The
DataLoader/MX product can help you streamline this task. DataLoader/MX is a
nonprivileged batch program that provides a library of command routines for loading
and maintaining SQL/MX tables. DataLoader/MX can be customized to perform
data-format transformation while using the import utility for append operations. For
more information about the DataLoader/MX product, see the DataLoader/MX
Reference Manual.
Guidelines for Appending Data to Tables
•
Use the import command to add data to a table or partition without purging
existing data.
•
Use import to add data to SQL/MX tables. You cannot use import to add data to
ASCII files or any other files other than SQL/MX tables.
•
import can use ASCII source files or input files from DataLoader/MX.
•
Use import to insert data into an audited table without resetting the audit
attribute.
•
If an error occurs during an append operation and import is able to terminate
gracefully, no new data is added to the target table for the last transaction run. To
determine if an append operation succeeded, check the listing to see if error
messages occurred.
•
If a CPU failure, process failure, BREAK command, or event interrupts an import
operation, import terminates with the table still in a valid state. Rows are
committed based on the -T option if that option is specified. For more information
about import, see the SQL/MX Reference Manual.