• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

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

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.

Thanks
0
peteredm
Asked:
peteredm
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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..
0
 
k_murli_krishnaCommented:
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:
http://www.xtivia.com/downloads/Federating_MS-SQL_Server_Tables_in_DB2_3-21-2005_v3.pdf
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now