Re: DB2/400 and MS SQL server

[Bill <brobins3d@xxxxxxxxx>]

Lance Gillespie wrote:
> I am looking for a way populate a SQL Server table with
> DB2/400 data.
>
> In a perfect world I would be running this tool on the 
> Windows box and it would update SQL server whenever the
> DB2/400 data changes.  In a less perfect (but still OK)
> world, it would update on a schedule.

Lance, when we were looking at a barcode solution, they used a software 
package by the name of, I believe, Orion.  Orion used triggers on the 
desired files to drop the data down to the desired SQL tables.  It 
produced a real time duplicate of the iSeries data tables.  Filtering 
could also be specified if only a subset of the data was required.

Bill