Re: Multiple transaction block

Posted in 2004

Jonathan Leffler — Wed, 07 Apr 2004 05:47:40 GMT — source: Usenet: comp.databases.informix

Pramod wrote: > I am writing an ESQL/C application for Informix database. > Can some one tell me how to simulate nested Transaction block > in informix You explain what you mean by 'nested transaction block' and maybe we can explain how to do it. However, if you are after savepoints, or: BEGIN WORK ...SQL BEGIN WORK ...SQL COMMIT WORK ...SQL ROLLBACK WORK The answer is 'no can do' - at least, AFAIK. (More precisely, the second BEGIN WORK will fail; what happens next depends on where you write that code.) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/