How do link get to tables and stored provedures from Linux/DB2 to windows 2003/SQL server 2000?

Posted on 2009-02-17
Last Modified: 2012-05-06
Working with IBM Websphere Broker Toolkit on a Redhat Linux box with a DB2 database for the broker, need to get data from tables and stored procedures in a SQL Server 2000 database on windows 2003 on the same network.

Any thought grateful.

Question by:peteredm
    LVL 57

    Accepted Solution

    Have you tried using Federated Servers?
    Using the above, we can create and access tables in SQL Server.
    I am afraid that you cant connect to procedures instead run the procedure and insert it into a temp table and create links for those temp tables.

    All versions and editions of DB2 wont support Federated Servers.
    Kindly give me your version and edition of DB2 so that we can check this out..
    LVL 17

    Assisted Solution

    You need to turn on your database configuration parameter to FEDERATED = YES in DB2 end and a similar configuration on SQL Server end. You will access DB2 tables by creating wrapper, user mapping, server and nickname and SQL Server tables from DB2 end using a 4 part name i.e. SQLServerName.DBName.SchemaOrOwner.TableName. You can access from either side procedures. If it is well within DB2 databases and SQL Server ones, then it is called distributed computing but you need to configure less for this.

    Please refer:

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now