Views between different databases 
Author Message
 Views between different databases
Hi All,
   Can anybody explain how this can be achieved?

Views between different databases i.e., database A would have a table
that would be viewable by database B.  Database A may be on a different
server than Database B, or they may be on the same server.

Thanks,
Ramya.

Sent via Deja.com http://www.***.com/
Before you buy.



Sun, 12 Jan 2003 03:00:00 GMT
 Views between different databases

Take a look into DB2 V7.1 federated features.

Cheers
Serge



Sun, 12 Jan 2003 03:00:00 GMT
 Views between different databases
Thanks for the response. Currently we are running UDB V5.2 on Win NT
4.0. Does that mean that this cannot be achieved in present
configuration.

Once again thanks for the info.
Ramya.



Quote:
> Take a look into DB2 V7.1 federated features.

> Cheers
> Serge

Sent via Deja.com http://www.deja.com/
Before you buy.


Sat, 18 Jan 2003 03:00:00 GMT
 Views between different databases
You would need DataJoiner then on top of DB2 V5.2. This is the separate
product which we are currently merging into V7.1 and higher.

Cheers
Serge



Sat, 18 Jan 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. View fro different Database

2. Different SQL Server's Approaching View in different ways

3. Different views with same name for different users

4. create view with two different database

5. View of tables in different database servers

6. SELECT permission denied.....view that reads from different databases

7. optimize View on Tables on different databases

8. One database server with different character set and sort order for different database

9. Compare the Fields in the 2 different TABLES in the 2 different DATABASE

10. Tables in queries from different databases which reside on different SQL 6.5 Servers

11. Joining 2 different InterBase Tables with 2 different Database

12. Joining 2 different InterBase Tables with 2 different Database


 
Powered by phpBB® Forum Software