Remote SQL Pass-Through (RSPT) Facility

Example 2: Accessing a DBMS Server

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);