Re: 2 Different Database Transactions
That's OK. I got it by doing as follows:
begin work;
insert into db1@server1:tab1 values ...update db2@server2:tab2 set ...
commit work;
Cheers,
Dorn.
----- Original Message -----
From: "Dorn Bhechsonggram" <dorn@bakcommunications.com>
To: "informix-list" <informix-list@iiug.org>
Sent: Monday, March 01, 2004 02:04 PM
Subject: 2 Different Database Transactions
> 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
sending to informix-list
Dorn Bhechsonggram wrote:
> That's OK. I got it by doing as follows:
>
> begin work;
> insert into db1@server1:tab1 values ...> update db2@server2:tab2 set ...
> commit work;
Yes that's the best way.
You couldn't do it the other way without somehow starting an XA-style
transaction, and having both connections associated with the same
GTRID (global transaction ID). That can be done in C (ESQL/C). I
don't think it can be done in DB-Access or friends.
> ----- Original Message -----
> From: "Dorn Bhechsonggram" <dorn@bakcommunications.com>
>
>>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.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/