begin works and commit works in storeprocs
Posted in 1997
I am new to informix .We are working on informix 7.1. I want to know if I can begin work and commit inside a storeproc. Before you answer here is the problem.It is in a foreach loop.I want to process transactions that I get with the foreach select statement and these transactions is in groups of 5 transaction that must be committed together.If one of these is wrong it must be rolled back otherwise it must be committed. here -- \\\\:// http://www.geocities.com/Area51/9680/ (o -) mailto:rudolph@aqumen.co.za ------------ooO-(_)-Ooo------------------------------------------ .oooO ( ) Oooo. Rudolph Terblanche -------\\ (----( )---------------------------------------------- \\_) ) / (_/ A Harmless instrument in the Hands of a Fool, is DANGEROUS !!!!