Re: Heterogenous distributed transactions (was RE: best way to refresh (copy) DB2 files to MySql(on windows))

Not strictly related to the OP, but how do distributed transactions work
between different database engines (DB2 and MySQL as below, Oracle and
SQL Server, etc.)? I presume DRDA is one way if all the platforms in the
transaction support it. Does JDBC have distributed transaction support?
(Obviously I'm not that familiar with JDBC.) I have used distributed
transactions in SQL Server environments and it works pretty well.

--Loyd


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gerald
Sent: Tuesday, January 06, 2009 1:48 PM
To: midrange-l@xxxxxxxxxxxx
Subject: best way to refresh (copy) DB2 files to MySql(on windows)

10 files need "refreshed" every night.
I do have the JDBC stuff working on the system i,
but was wondering if there was a better way to
get the data into the MySQL database.

Thanks...

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.