Question { CTS, 4834 }
If we execute an query in MLOAD it's ran successfully,
my questions is after successfully ran MLOAD. In error
tables we can see anything there! is it possible than what
are they?
Answer
THREE COLUMNS SPECIFIC TO THE ACQUISITION ERROR TABLE
Error Code: System code that identifies the error.
Error Field: Name of the column in the target table where
the error happened; is left blank if the offending column
cannot be identified.
Host Data: The data row that contains the error.
THREE COLUMNS SPECIFIC TO THE APPLICATION ERROR TABLE
Uniqueness: Contains a certain value that disallows
duplicate row errors in this table;can be ignored, if desired.
DBC Error Code: System code that identifies the error.
DBC Error Field: Name of the column in the target table
where the error happened; is left blank if the offending
column cannot be identified.
NOTE:A copy of the target table column immediately follows
this column.