Post reply

sql server 2000 data to db2?

  • December 22, 2004 at 7:06 am

    #163400

    hi folks,

    not sure if this is the right place for this post....

    problem;

    my company has a time management system running on sql server 2000.  however the main company system is SAP which is running on db2/as400.

    i somehow need to get the contents of a stored proc/table or view replicated into a table on the db2/as400 so that i can access the data from sap.. (SAP on db2 will not interact directly with sql server databases.)

    can anyone give me any clues?

    do i push the table/view etc from sql into db2 or do i pull it from te as400?

    does anyone have any experience of this?

    thanks, drew.

  • December 23, 2004 at 5:57 am

    #534880

    Check out 'sp_addlinkedserver' in SQL Books Online

  • December 23, 2004 at 11:05 am

    #534914

    We have a linked server to a DB2/As400 using an ODBC and can pull data fine.  Never tried a push, but it probably depends on the driver.  We also us an OLE DB driver called HiT to push data to an AS400, but it's also supposed to be able to push to DB2 as well.  Not too expensive if you want to check it out http://www.hitsw.com/

    Linda

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply