Re: DB2/400 and MS SQL server

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

I usually populate SQL Server tables from SQL Server itself. Create a linked
server to DB2. You will need to install iSeries Access, but just the ODBC
drivers. Here is what a linked server setup looks like (SQL Server 2005 with
v5r4 iSeries Access installed):


Linked server: myas400test
Provider: Microsoft OLE DB Provider for ODBC Drivers
Product name: DB2 UDB for iSeries
Data source: MyAs400Test
Provider string: CMT=0;SYSTEM=10.0.0.1
Catalog: <System serial number>

You query like this:
select *
from DB2400.SYSNAME.QSYS2.SYSTABLES
where system_table_schema='QSYS2'
I've found the four-part name must be in upper case.

HTH,
Loyd


On Thu, Apr 15, 2010 at 10:55 AM, Lance Gillespie <LGillespie@xxxxxxxx>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.
>
> Currently we ftp the DB2/400 data to the server as CSV
> and use the Microsoft import tool.  This works, but lacks
> aesthetic appeal.
>
> I would also like to be able to use a TOAD-like tool from
> a workstation against DB2/400 tables.
>
> These could be different solutions.
>
> I tried IBM DB2 CONNECT, but could not get it installed
> properly before the evaluation period expired.
>
> Vendor solutions welcome.
>
> Thanks,
> lance