The following information refers to the DATALOAD and DATAUPDATE statements.
LOAD reads the records of the source file sequentially. Each record is tested to determine which target file fulfills the selection criterion. Per target table, one table row is created for each selected record.
Rows being inserted into the table may be rejected by the database because they violate the integrity of the database (e.g., duplicate key value). Rejected rows are recorded in the protocol file along with the error message (see chapter The LOAD Session Log).
During execution, two counters keep track of the number of rows inserted or rejected for each statement and target table.
The current counter readings for the relevant target table are displayed if one of the following conditions is true:
a) The current transaction was terminated because the number of rows determined by the transaction size (SET parameter) was inserted.
b) The current row was incorrect and could not be inserted.
Once the end of the source file is reached, the counter readings are accumulated. In the case of a DATALOAD statement, the total number of processed and rejected rows is displayed on the screen. The sum of the two figures corresponds to the number of executed INSERT statements. The displayed message has, e.g., the following format:
Sum of inserted lines : 5241, sum of rejected lines : 9
In the case of DATAUPDATE statements, it is always the number of modified rows which is displayed. The accumulated message has the format:
Sum of updates : 9822, sum of invalid lines : 3
The respective message is also written into the protocol file.