IBM 000-8697 Bedienungsanleitung Seite 498

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 702
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 497
7-20 IBM Informix OnLine Database Server Administrator’s Guide
Bad-Row Limits
Bad-Row Limits
Ifyouset-enumber errorsreadtoaninteger,dbloadterminateswhenitreads
(number errors read +1) bad rows. If you set the value of number errors read to
0,dbloadterminateswhenitreadsthefirstbadrow.Thereisnodefaultvalue
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.
Ifdbloadexceedsthebad-rowlimitandthe-poptionisnotspecified,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,unlessyouspecifyotherwise,dbloadcommitsanynewrowsthathave
been inserted since the last transaction.
-e number errors read specifiesthenumberofbadrowsthatdbloadreads
before terminating.
-p promptsforinstructionsifthenumberofbadrows
exceeds the limit.
-e number errors read
-p
Bad-Row
Limits
Seitenansicht 497
1 2 ... 493 494 495 496 497 498 499 500 501 502 503 ... 701 702

Kommentare zu diesen Handbüchern

Keine Kommentare