Re: dbload rejects

Keith Ford wrote: > > Running Informix 4.10 on SCO. > > When dbload runs it allows me to specify how many rows to insert before > doing a commit work. If any duplicate keyed records are inserted they are > rejected and displayed. Now, when I try to do something similar with code > using ESQL/C it doesn't work. The inserts do not fail. I only get an > error when I perform the commit work. Does anyone know what my problem is? > (Other than using ancient software? <grin>) > > -- > -- Keith Ford, Micro Magic, 205-971-9711 > -- http://www.magicbbs.com If you use the PUT statement, it inserts the rows into a buffer. The actual insert happens during a COMMIT WORK. This is when constraints are checked. You can make the buffer flush happen when you want (at some cost to efficiency) with the FLUSH statement. RTFM on PUT and FLUSH: it is, as usual, explained quite clearly there. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/