Passthru SQL (from Fraktal SAS Programming): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K |
K |
||
| Zeile 28: | Zeile 28: | ||
| | | | ||
( | ( | ||
| − | | ''' | + | | '''Open passthru SQL channel using a left bracket''' |
|- | |- | ||
| | | | ||
| Zeile 41: | Zeile 41: | ||
| | | | ||
) | ) | ||
| − | | '''Close passthru | + | | '''Close passthru SQL channel using a right bracket''' |
|- | |- | ||
| | | | ||
| − | + | by oracle | |
| '''Trigger execution using the DBMS connection opened before''' | | '''Trigger execution using the DBMS connection opened before''' | ||
|- | |- | ||
Version vom 30. Juni 2014, 16:34 Uhr
|
|
|
|
| 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 |
( |
Open passthru SQL channel using a left 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 SQL channel using a right 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 |
|
|
|
|
