Set AutoCommit equivalent

Posted in 2004

LLOYD SERRAO — Wed, 27 Oct 2004 09:29:20 — source: IIUG Forums & Mailing Lists

Whats the set autocommit equivalent in informix. I have a script which calls 5 procedures, if anyone fails all the other should rollback. But its not happening. I have also set DBACCNOIGN env variable to 1.

↪ replying to LLOYD SERRAO

Jesus Antonio Santos Giraldo — Wed, 27 Oct 2004 11:13:51 — source: IIUG Forums & Mailing Lists

It looks like you have to use transactions. LLOYD SERRAO wrote: > Whats the set autocommit equivalent in informix. I have a script which calls 5 procedures, > if anyone fails all the other should rollback. But its not happening. > I have also set DBACCNOIGN env variable to 1. > >