Re: Loading Table Informix 5

Posted in 2000

Obnoxio The Clown — Thu, 23 Mar 2000 11:35:43 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >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 And I should RTFQ. SET VIOLATIONS isn't in 5. Sorry. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com