Re: Batch Processing

Chris Drauch wrote : }Mik Hobbs wrote }} }}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. }}> }}>: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. } }I wouldn't be that strong :-) we use isqlPERL typically for such jobs. And }that means less headache than doing the job with C/C++. Perl is still one of }the best RAD tools - specially for batch jobs. If you have I4GL, it will be much easier to write a C-function (it may be available in user-group software repository) to read ASCII-file into I4GL-string and to modify the database. In this case except the C-function everything else can be written in I4GL. If you are using Informix-RDS, this could be much faster to develop, than any other Rapid-Development-Tools, at least I think so. Felix Koshy Mathews fmathews@systems.dhl.com