Filter
Top Products
7-20 IBM Informix OnLine Database Server Administrator’s Guide
Bad-Row Limits
Bad-Row Limits
If you set -e number errors read to an integer, dbloadterminates 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.
If dbload 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.
If dbload 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
dbload reads 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.
-e number errors read specifies the numberof bad rows that dbloadreads
before terminating.
-p prompts for instructions if the number of bad rows
exceeds the limit.
-e number errors read
-p
Bad-Row
Limits