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

55 12345678
--- 4 row(s) selected.
The X.perrs file will contain:
A8,22345678
14,423456789
17,52345678,9
BZ,XYZ
The X.perrmsg file will contain:
*** ERROR[20081] Row number 2 and column number 1 could not be
processed. Column Data: A8
*** ERROR[20291] The data specified in row number 4 column
number 2 is longer than the actual column size definition.
Column Data:123456789.
*** ERROR[20070] Columns in the datafile are not correct.
Columns found so far: 3
*** ERROR[20081] Row number 9 and column number 1 could not be
processed. Column Data: BZ
The X.xerrs will contain:
11,82345678
5,32345678
The X.xerrmsg file will contain:
*** ERROR[8102] The operation is prevented by a unique
constraint.
*** ERROR[8101] The operation is prevented by check constraint
CAT.SCH.CND1 on table CAT.SCH.XAMPLE.
The results summary file, X.sum, will contain:
Import Results Summary
Import Process ID: 4060
Input File or Process Name: X.in
Start time: Mon Oct 15 13:12:43 2007
Rows to be skipped initially: 0
Rows read so far = 10
Rows skipped = 0
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.
Using import to Load SQL/MX Tables 205