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

samabdelmalek@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