SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-55
Examples of import
The X.perrs file would contain:
A8,22345678
14,423456789
17,52345678,9
BZ,XYZ
The X.perrmsg file would 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 would contain:
11,82345678
5,32345678
The X.xerrmsg file would 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.