Re: HELP: DBD::Informix issues

"Jonathan Leffler" <jleffler@earthlink.net> wrote in message news:3EDC370E.60509@earthlink.net... > Douglas Wilson wrote: > > On Mon, 2 Jun 2003 21:59:16 -0400, "George Karabotsos" <karabot@canada.com> > > wrote: > > > >>1) Why am I not getting error "-255 Not in transaction" error from the two > >>"COMMIT WORK" statements above? > > > > With DBI and AutoCommit set to zero, you are always in a transaction, and > > after every commit there is an implicit BEGIN WORK. > > Correct - though internally to DBD::Informix, the BEGIN WORK is > explicitly put there. I thought that was the case through the DBI->commit() call only. As you can see I do not use this method, instead I use DBI->do('COMMIT WORK'). Do you mean that irrespective of how a commit is done, an explicit BEGIN WORK will be executed through DBI? Also consider the case where an SPL is called through PERL and that SPL contains COMMIT or a ROLLBACK, will DBI do an explicit BEGIN WORK? I 'll try to write something simple to reproduce this for you tomorrow, I need to get some sleep now :-) thanks again for the help guys. George.