The MESSAGE LOG file contains row and column information for each integrity constraint violation logged.
A given load includes a timestamped header, row information, and a timestamped trailer. The header appears once per load. The trailer appears once if the statement executes successfully. The row information appears once for each integrity constraint violation logged.
<datetime load started> Load Table <table-name>: Integrity Constraint ViolationsFor example:
2009-05-24 23:04:31 Load Table Customers: Integrity Constraint Violations
The row information message consists of:
The row number within the table where this row would have been loaded, if an integrity constraint violation had not occurred.
The type of integrity constraint violation detected.
The column specified by the schema.
1267 DATA VALUE 4 3216 UNIQUE 1 3216 NULL 3 3216 NULL 6 9677 NULL 1
<datetime load completed> Load Table <table-name> CompletedFor example:
2009-05-24 23:05:43 LOAD TABLE Customers: Completed