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,

Lakshmanan

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.

Andy