/**********************************************************************/


proc sql;
   connect to rdb (database='disk1:[multrdb]devlpmnt.rdb');


/**********************************************************************/


execute (declare s1 schema filename
     disk1:[multrdb]support.rdb) by rdb;
execute (declare s2 schema filename
     disk1:[multrdb]sales.rdb) by rdb;


/**********************************************************************/


select * from connection to rdb
   (select area, product from host
      where area like 'va%');

select * from connection to rdb
   (select last_name from s1.analysts
      where level > 3);

select * from connection to rdb
   (select acct_num, product from s2.accounts
      where product = 'access');


/**********************************************************************/


create view prd_info as
   select * from
      connection to rdb (select * from host) as dev,
      connection to rdb (select * from s2.accounts) as sal
                 where dev.product = sal.product;


/**********************************************************************/


select * from prd_info;


/**********************************************************************/