2 Different Database Transactions

Posted in 2004

Dorn Bhechsonggram — Mon, 1 Mar 2004 14:04:20 -0800 — source: Usenet: comp.databases.informix

I just wonder whether anyone can give me some recommendations. If I need to execute the query in 2 different databases as follows: --1st connection begin work; insert into table1 value ('x'); --2nd connection update table2 set column1 = columns2;commit work; I want both transaction to complete and then commit. My question is whether I can issue just 1 BEGIN WORK/COMMIT WORK for both connection and it will commit for both queries. I am not sure if I explain clearly. Please let me know. Thank you. Dorn. sending to informix-list