RE:Database Link

From: <R.RASAL_at_ponl.com>
Date: Wed, 3 Jan 2001 13:38:00
Message-Id: <10730.125580@fatcity.com>

Yes , certainly we can .

I have used it .
It was with help of a additional software i.e. Oracle - DB2 transparent gateway ( there is also one procedural gateway , but don't know much about that ) .
If the gateway is installed on the DB2 side ( mostly mainframe ) , then we can create a DB link as if creating a DB link to any other remote Oracle database . I am not aware of the details of commit - rollback mechanism of DB2 , but when we use a gateway , the locking on the DB2 side may show us many funny ( practically serious ) things .

At least I am not aware of any other mechanism of interacting with DB2 from Oracle .

Cheers ,
Rahul Rasal
UK Mobile No. : 07787824194 Received on Wed Jan 03 2001 - 13:38:00 CST