Re: ISQL Begin Work & Commit Work

zprj1@nottscc.gov.uk (Jevon Richard) wrote: :Please could anyone tell me how to use the BEGIN WORK, COMMIT WORK and :ROLLBACK statements in ISQL. : :The main question is How do you find out what the status of an UPDATE, :INSERT so to determine whether to ROLLBACK or COMMIT WORK ?? : :Am i missing the point ? No, you are not missing the point. The problem is it can't be done inside a single session. There would have to be some kind of if statement, which there isn't. In a recent post John Morgan (mudshark@mindspring.com) also posted about the same problem. He said he might write his own tool to do exactly this. Otherwise the real answer is to use a language (4GL, ESQL/C or whatever development language you have). Although Informix ought to have implemented a simple language inside dbaccess (and the new GUI tools as well) I doubt a little that they will. One problem is that if you had an if-statement you also want a print statement (to print error messages), and display, and mail, and and and... In the end you got a complete development language and can as well use one of the available once. In my opinion you should be very carefull with using anything but a full programming language for production systems. 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