DB2 AS400 Snapshot
This is a discussion on DB2 AS400 Snapshot within the DB2 forums, part of the Database Server Software category; --> This is more a hypothetical question, but anyhow...we have the following problem: There is a possibility that, in the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:56 AM
| ||||
| ||||
 DB2 AS400 Snapshot 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?      |
|
02-27-2008, 07:56 AM
| |||
| |||
| Re: DB2 AS400 Snapshot 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 |
|
02-27-2008, 07:57 AM
| ||||
| ||||
| Re: DB2 AS400 Snapshot 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? |
Linear Mode
