Re: LOAD (ignoring errors), constraint violations

Jason Harris wrote: > > On Tue, 02 Sep 1997 13:52:35 -0600, aheller@visa.com wrote: > > There may be a way. You can try setting the contraints on the table to > filter mode which will allow rows to be inserted that dont violate the > constraints but not allow constraint violations, such as primary keys > etc. > > Dont know if this covers all possible errors. > > Regards, > > Jason > > > > >What I'd really like to do is run the LOAD command within DB-ACCESS and > >have LOAD ignore any errors it gets along the way (instead of blowing > >up). Does anyone know if this is possible (if so, the syntax) or do I > >have to use DBLOAD > > > >Thanks in advance > > > >-------------------==== Posted via Deja News ====----------------------- > > http://www.dejanews.com/ Search, Read, Post to Usenet Version 7.1 has this feature of being able to copy information about constraint violations to another table and continue the load. I have used it and it's great. It is particularly useful for non-unique violations. It won't solve problems of trying to convert a text non-number to a number. To do that you'd need an intermediate table and some code of your own to check the text. If you do not have a huge amount of data to deal with you could use awk or perl. Peter -- Peter Lancashire Mail: Peter.Lancashire.PL1@bayer.co.uk Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 All opinions are my own and not those of Bayer plc.