Remote SQL Pass-Through (RSPT) Facility

Examples

Here are examples of processing data by using RSPT.

The following program joins two server data sets (RSPT through a server).

proc sql;
   connect to remote(server=sdcmvs.prx6xhsrv);
   select *
   from connection to remote
      (select p.idnum   label='ID Number'
              p.jobcode label='Job Code'
              s.city    label='City'
       from rmtshr.staff s,
            rmtshr.payroll p
       where s.idnum=p.idnum
       orderby jobcode);

The following program uses RSPT to connect to a remote server to read data from a DB2 table (accessing a server DBMS with RSPT).

proc sql;
   connect to remote(server=sdcmvs.mktserv
                     dbms=db2 dbmsarg=(ssid=db2));
   select *
   from connection to remote
      (select flight#, orig, destination, delay
       from educ.db2delay
       where delay > 11);

Top of Page