Re: transactions lasting over two processes

Thomas; I believe that, by default, Informix Transactions will "span" spawned processes. So, if Process A starts a transaction and then spawns Process B, both A and B are running under the same Transaction. Thus, if Process B performs a ROLLBACK, both A's and B's updates are rolled back. Likewise for COMMITS. If you wanted Process A's and Process B's Transactions to be independent, you would issue a call to sqldetach() from with Process B to disconnect Process B from the parent's (Process A's) transaction (database connection). You would then explicitly start a new transaction from Process B. Process A's DB transaction would still be intact, but would be independent from process B's. Thomas Kieninger (kieni@dfki.uni-kl.de) wrote: : Hello out there, : I have a quite silly question, but I would really like : you to give me serious comments if possible: : Is it possible to start a transaction from within one : application (process) and stop (rollback or commit) it : from within another application?