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);
Copyright © SAS Institute Inc. All rights reserved.