vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |