Subject | Transaction spanning 2 databases ... |
---|---|
Author | Bill Katelis |
Post date | 2002-09-19T01:24:43Z |
Platform: SCO/Unix IB 5.5 ESQL
Hi,
Can a single transaction span multiple databases ?
ie. (pseudo-code)
connect db1;
start work;
Call function to update db2;
update db1;
if error
rollback; (will this rollback changes to db2 ?)
commit work;
thanks
bill
Hi,
Can a single transaction span multiple databases ?
ie. (pseudo-code)
connect db1;
start work;
Call function to update db2;
update db1;
if error
rollback; (will this rollback changes to db2 ?)
commit work;
thanks
bill