I need to link multiple databases so I can select data in 1 query that will get all the data from each database. Does anybody know the easiest way to do this. All the databases are on the same server, different instances, AIX 5.2, V8 fixpak 5b.


Example:

Database 1 has customer table, Database 2 has additional customer data. We need to link those 2 tables together and list the output from the select.

You can do this with DB2 Federated support. Check the list of manuals for more information. A link for the IBM manuals is in the Useful DB2 Stuff thread.