By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,234 Members | 1,519 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,234 IT Pros & Developers. It's quick & easy.

DBLink to a SQL server

P: n/a
Hi,

is there a way in DB2 to have a db link to a remote table in SQL Server
2000 and be able to insert data in that table?
I have 2 systems that need to access the same information almost real
time (one app uses SQL Server and the other uses DB2) so immediately
after a user enters information in DB2, I would like the data to be
pushed real time into the SQL Server 2000 tables. I thought the easiest
way is to have a DBLink to those SQL tables and insert the data inside
DB2 if it is possible!

Any help or suggestions on a solution would be greately appreciated.
Sam

Aug 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes in DB2 UDB you can use

INFORMATION INTEGRATOR/FEDERATED DATABASES to accomplish this

1. Create wrapper

I think for SQL Server u have to use something like this

CREATE WRAPPER odbc LIBRARY 'db2rcodbc.dll'

check the CREATE WRAPPER statement for further details.

2. Create Server

3. Create usermappings

4. Create Nicknames

cheers...
Shashi Mannepalli

sa***********@gmail.com wrote:
Hi,

is there a way in DB2 to have a db link to a remote table in SQL Server
2000 and be able to insert data in that table?
I have 2 systems that need to access the same information almost real
time (one app uses SQL Server and the other uses DB2) so immediately
after a user enters information in DB2, I would like the data to be
pushed real time into the SQL Server 2000 tables. I thought the easiest
way is to have a DBLink to those SQL tables and insert the data inside
DB2 if it is possible!

Any help or suggestions on a solution would be greately appreciated.
Sam
Aug 16 '06 #2

P: n/a
Once you set this setup.....u can use REPLICATION to accomplish the one
u are mentioning....

Shashi Mannepalli
Shashi Mannepalli wrote:
Yes in DB2 UDB you can use

INFORMATION INTEGRATOR/FEDERATED DATABASES to accomplish this

1. Create wrapper

I think for SQL Server u have to use something like this

CREATE WRAPPER odbc LIBRARY 'db2rcodbc.dll'

check the CREATE WRAPPER statement for further details.

2. Create Server

3. Create usermappings

4. Create Nicknames

cheers...
Shashi Mannepalli

sa***********@gmail.com wrote:
Hi,

is there a way in DB2 to have a db link to a remote table in SQL Server
2000 and be able to insert data in that table?
I have 2 systems that need to access the same information almost real
time (one app uses SQL Server and the other uses DB2) so immediately
after a user enters information in DB2, I would like the data to be
pushed real time into the SQL Server 2000 tables. I thought the easiest
way is to have a DBLink to those SQL tables and insert the data inside
DB2 if it is possible!

Any help or suggestions on a solution would be greately appreciated.
Sam
Aug 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.