DB2 AS400 Snapshot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pakna - 18 Aug 2006 15:17 GMT

This is more a hypothetical question, but anyhow...we have the following
problem:

There is a possibility that, in the near future, we are to make a DB2
snapshot of a AS/400-based table to a Windows platform. Now, since we
have no real AS/400 systems to fiddle with ourselves, we figured one way
to do this is via Java stored procedure that would get the data from DB2
on AS/400 and then move them via ODBC to DB2 on Windows.

The question is - is that possible? Does the standard ODBC also natively
include support for AS/400?

Reply to this Message

John Bailo - 18 Aug 2006 21:47 GMT

> This is more a hypothetical question, but anyhow...we have the following
> problem:
[quoted text clipped - 7 lines]
> The question is - is that possible? Does the standard ODBC also natively
> include support for AS/400?

Why not write a web service interface to your DB400 data? Then you
could consume it as needed from a .NET client on windows?

(I do this all the time).

Signature

Texeme Construct
http://www.myspace.com/texeme

Reply to this Message

Pakna - 21 Aug 2006 11:37 GMT

>> This is more a hypothetical question, but anyhow...we have the
>> following problem:
[quoted text clipped - 12 lines]
>
> (I do this all the time).

So you would recommend web service over this direct replication
procedure? If so, why?

Reply to this Message