Re: Faulty BEGIN COMMIT on Informix 4.1

On Oct 27, 4:03am, rk wrote: > Subject: Faulty BEGIN COMMIT on Informix 4.1 > Need assistance from Informix gurus out there! > > Is there any guarrantee that statements inside a BEGIN-COMMIT would be > done atomically. We are using Informix 4.1 on top of AIX 3.2, and we > have discovered that several times the BEGIN-COMMIT in our programs > missed a statement or two without warning to users or rolling back the > transactions. It happens randomly both on small and large BEGIN-COMMIT > block. True this is rare, but we want to make sure that it > never happens at all. > > Your help would be appreciated. > > Thanks, > > andro@ibm.net Do you check the SQLCA.SQLCODE parameter after every SQL statement? If you don't then a statement can fail and the commit will still occur. SQL, and this is true for all SQL database engines, does not keep track of statement errors for you and do an automatic rollback. If you are not checking the error return it can appear that statements are being missed when in fact they are failing. I have never seen Informix 4.1 miss a statement unless this was the cause. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!