Re: ODBC Question

Posted in 2003

Manas Dadarkar — Mon, 1 Sep 2003 07:17:27 -0700 (PDT) — source: Usenet: comp.databases.informix

DB2 is the database I am using and it does not support the BEGIN WORKstatement. Also, if I set the AUTOCOMMIT feature on, we have a performance penalty and COMMIT WORK might return an error. Any other ideas? Thanks, -Manas --- Jonathan Leffler <jleffler@earthlink.net> wrote: > Manas Dadarkar wrote: > > Can anyone tell me whether it is possible to > know > > whether any transaction is running for an ODBC > > connection via ODBC/CLI calls? > > ODBC has AutoCommit. If it is on, you are not in a > transaction. > If it is off, you probably are in a transaction. > > You can always try executing a BEGIN WORK statement: > if it succeeds, > you were not in a transaction; if it fails, either > the database does > not support transactions (one error code) or you > were already in a > transaction. > > -- > Jonathan Leffler #include > <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- > http://dbi.perl.org/ > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com sending to informix-list