Re: Loading Table Informix 5
Posted in 2000
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
From: Jon Borys <jborys@rms.moore.com>
>
>I want to load a table from a text file using the load command. The
>table has unique key constraints on it and some of the records I'm
>attempting to load cause it to fail. Is it possible to have the load
>command keep loading after it has problem with a record and output to a
>file all of the records that failed to load? Thanks in advance.
RTFM. Look into dbload or SET VIOLATIONS
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com