7-20 IBM Informix OnLine Database Server Administrator’s Guide

Bad-Row Limits

Bad-Row Limits
Ifyou set -e number errors read to an integer, dbload terminates when it reads
(number errors read +1) bad rows. If you set the value of number errors read to
0,dbload terminates when it reads the first bad row.There is no default value
for number errors read.
Ifdbload exceeds the bad-row limit and the-p option is specified, dbload
prompts you for instructions before it terminates. The prompt asks you to
indicate whether you want to roll back or to commit all rows inserted since
the last transaction.
Ifdbload exceeds the bad-row limit and the -p option is not specified, dbload
commits all rows inserted since the last transaction.
If you do not specify the-e option, the default is 10. This means that after
dbloadreads the eleventh bad row, it terminates. In a database with transac-
tions,unless you specify otherwise, dbload commits any new rows that have
been inserted since the last transaction.
-enumber errors read specifiesthe number ofbad rowsthat dbload reads
before terminating.
-p promptsfor instructions if the number of bad rows
exceeds the limit.
-enumber errors read -p
Bad-Row
Limits