Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    12

    Question Unanswered: How to select to tables of two data bases in a SELECT statement?

    Hi, All.

    How to select to tables of two data bases in a SELECT statement?

    I have two data bases, each db in a different server.


    Thanks advisors,


    Wil.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You will need to implement federated database support in DB2. This allows you to set up aliases for one the tables on a different database (regardless of which server the database is located at).
    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
  •