• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • 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.

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..
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:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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