The following Pass-Through Facility example sends a query to an ORACLE database for processing: proc sql; connect to oracle as myconn (user=smith password=secret path='myoracleserver'); select * from ...

(DBMS-SQL-query) specifies the query that you are sending to the data source, such as a relational DBMS. Data sources other that relational databases can be specified in the SQL Procedure Pass-Through ...