Re: Batch Processing

Bryan Valencia <bryanv@thevision.net> wrote: ...snip... :> }>:How do you update random rows within a table using data located with :> }>:an external flat file? ...snip... :Must interject: Delphi is a powerful tool for this type of task too. :) :Don't be such a C snob <vbg>. :Bryan Valencia :Software Services - Making Windows Scream :Modesto, CA I just want to clearify a misunderstanding here: You may be able to make Windows screem using Delphi, but as a general solution it is not a *powerfull* tool for this type of updates. A general solution would be able to read very large amounts of data from the flat files and updating (update, insert, delete) the database from it. It should be generally known by now that this is the kind of thing you don't want to do from a client. It should normally be run on the server - if there is a significant amount of data. Of course Delphi and other similar tools are fine for relatively small amounts of data or if your server is Windows NT and you run the program on the server. 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