Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: stored procedure

    I have a clarification on stored procedures. Can a stored procedure be written for selecting all the fields from 2 tables with same table name and schemas. present in different databases.

    Whether this is possible in Databases such as SQL server and DB2?

    Thank you,


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Yes. You need to read about "Federation". It will explain how to set up DB2 to have access to both tables as if they were in the same database. Then you can write the stored procedure.


Posting Permissions

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