Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Unanswered: Linking Multiple database on same server

    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.
    David Quigley

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •