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-37
Examples of Using import to Load an SQL/MX Table
A select statement on the table will show the following:
select * from cat.sch.Xample;
C1 C2
----------- --------
11 12345678
15 62345678
27 72345678
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