IBM 000-8697 User Manual
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, 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.
(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.
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.
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
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.
been inserted since the last transaction.
-e number errors read
specifies the number of bad rows that dbload reads
before terminating.
before terminating.
-p
prompts for instructions if the number of bad rows
exceeds the limit.
exceeds the limit.
-e number errors read
-p
Bad-Row
Limits