Re: Batch Processing

In <V80eeFAB7GpyEw4f@bbt-ltd.demon.co.uk> Mik Hobbs <BBT@bbt-ltd.demon.co.uk> writes: > >Anyone trying to do batch updates in anything other than ESQL/C is going >to give themselves a headache !! > >C is ideal for reading flat files and combined with the power of >embedded SQL, there really is no substitute. > >Mike. > >In article <580n7c$tcj@nntp.idgonline.no>, Nils Myklebust ><Nils.Myklebust@idg.no> writes >>david@temss2.main.temple.edu (David Tucker) wrote: >> >>:How do you update random rows within a table using data located with >>:an external flat file? >> >>We use some of the file io rutines available in the software >>repository at http://www.iiug.org to read the files in 4GL and do the >>updates. >> >> >>Nils.Myklebust@idg.no >>NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway >>My opinions are those of my company >>The Informix FAQ is at http://www.iiug.org >> Mr Hobbs: I won't disagree with your assessment of "C" and ESQL/C, but I don't recommend you run out and buy ESQL/C just for this particular problem. If all you have is Informix 4GL, you can solve this problem is serveral ways, and you can be assured that the headaches are minimal. Over the years I've solved this particular problem many times. I've already posted a solution, so if anyone has missed it and wants it, e-mail me and I'll provide it. regards, ed schaefer