SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:55 AM
| ||||
| ||||
 DBLink to a SQL server 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      |
|
02-27-2008, 07:55 AM
| |||
| |||
| Re: DBLink to a SQL server 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 |
|
02-27-2008, 07:55 AM
| ||||
| ||||
| Re: DBLink to a SQL server 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 > > 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 |
Linear Mode
