multiple transactions?

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/