Re: "Load from" SQL Statement ...
Rick Nath (rnath@wrbc.com) wrote:
: I was wondering if anyone has stumbled upon a way in which to continue
: processing a 'load' file even after it has encountered an error (such as
: duplicate key) within the file? We have process written that takes a
: delimited file and attempts to load. If there are no errors everything is
: fine. However if there is an error such as a duplicate key, the loading of
: the entire file stops and we are forced to go through the entire file to
: find the bad record, remove it, and restart the process. Other options
: such as SPs and 4GL are welcome.
: Rick Nath
Try dbload.
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998
from Prentice Hall/Informix Press.
---------------------------------------------------------------------------