Re: load and unload and update

> A few days ago I posted a question about the format of UNLOAD. > > I am generating csv files from my MS Windows app to upload to the > Informixdatabase (on Unix). I can dbload them if they are brand new > records -but if they are updated versions of existing records then > dbload refuses to update them - since it tells me there would be > duplicate recordsand unique keyed indexes. Can I use some kind of sql > LOAD statement to load and/or update records? or can I use dbload to > update existingrecords - as well as load new ones? > > > --- > > > Any Informix contractors in the south east of England > (London/Hertfordshire)who feel they can help with connecting MS Windows > Apps to Informix on Unixplease contact me. > > > -- > Alex McLintock [also alexmc@biccdc.co.uk] > Editor for the Project Galactic Guide (alt.galactic-guide) Number 6 Alex, if DBLOAD objects to the records so will LOAD. In fact any packaged solution will fail in that way. I think you will need some more specialist help. I could help you, but I am heavily committed until mid December. Still you can always call me if you wish. I note from your other mail address the hostname biccdc. Is this anyhting to do with BICC? If so, I have just completed training Michael Davies from BICC Liverpool. He seems to know his way around the subject quite well. Are you a member of INFUSE? If not why not join. Just call 081-421-3533 and quote my name! They'll send you more details.