is it possible to establish multiple (subordinate) transactions in
Informix?

Thanks!

BigBob wrote:

> is it possible to establish multiple (subordinate) transactions in
> Informix?

In theory, it depends on what you mean by multiple transactions, but
the basic answer is No.

IDS does not support SQL-1999 savepoints. It does not permit you to
start a transaction within another transaction - so you can't commit
an inner transaction and still have the outer transaction rollback the
inner transaction.

What you can do is have several independent connections to IDS (the
same server, or different servers) and do separate work on each
connection. Remember the WITH CONCURRENT TRANSACTIONS option!

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/