By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,276 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,276 IT Pros & Developers. It's quick & easy.

DB2 AS400 Snapshot

P: n/a
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?
Aug 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Pakna wrote:
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?
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).

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

Aug 18 '06 #2

P: n/a
John Bailo wrote:
Pakna wrote:
>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?

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).
So you would recommend web service over this direct replication
procedure? If so, why?
Aug 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.