Passthru SQL (from Fraktal SAS Programming)
|
|
|
|
| Code executed | Function performed |
|---|---|
proc sql; |
Start the SQL interpreter inside SAS |
connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH."); |
Open connection to the DBMS using your credentials stored in Macro Variables |
execute |
Trigger execution of passthru code by the SAS SQL interpreter |
( |
Start passthru code using a bracket |
create table my_ora_tab as |
Type your Oracle SQL code as if you were using some Oracle client or frontend |
select * from ops$&DB_USR..&MYTABLE. |
Inside brackets use DBMS specific SQL |
) |
Close passthru code using a bracket |
by oracle |
Trigger execution using the DBMS connection opened before |
; |
Execute the query by issuing the SAS statement terminator ';' |
disconnect from oracle; |
Close connection to DBMS |
quit; |
Terminate SAS SQL interpreter status |
|
|
|
|