commit and set autocommit equivalent ?

SamCute · #1 (**permalink**) 07-08-04, 04:59

Hi,

What is the Informix equivalent for "set autocommit on" and "commit" statement of Oracle ?

Thanks,
Sam

lloydnwo · #2 (**permalink**) 10-26-04, 05:57

Hi Sam,

Did u get an answer for it, i too am looking for a solution.

Regards,

lloyd

SamCute · #3 (**permalink**) 10-26-04, 23:56

Hi,

I was able to see the equivalent with the below SwisSQL tool :

http://swissql.com/swissqlconsoledownloadform.htm

It was a very usefull tool and the support was good.

The equivalent is "set autocommit off/on"

Try it out.

Regards,
Sam

lloydnwo · #4 (**permalink**) 10-27-04, 00:07

Hi Sam,

Thanks for your feedback, i have been using Winsql in which too i can set Autocommit off/on. But i need to do it from the backend using dbaccess.
Any ideas.

Regards,

lloyd

Internet Services

Web Development

Digital Marketing

Consumer Tech