Hybrid Queries (from Fraktal SAS Programming): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K |
K |
||
| Zeile 1: | Zeile 1: | ||
| − | [[Kategorie: | + | [[Kategorie:zazy]] |
| + | {{SeitenNavigation1 | ||
| + | |links=xx_left.png | ||
| + | |zurück=Libname Engine (from Fraktal SAS Programming) | ||
| + | |rechts=xx_right.png | ||
| + | |vorwärts=Passthru SQL (from Fraktal SAS Programming) | ||
| + | |hoch=Duck_zazy_com.png | ||
| + | |übersicht=DBMS Interaction (from Fraktal SAS Programming) | ||
| + | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
| Zeile 38: | Zeile 46: | ||
| '''Terminate SAS SQL interpreter status''' | | '''Terminate SAS SQL interpreter status''' | ||
|} | |} | ||
| + | |||
| + | {{SeitenNavigation1 | ||
| + | |links=xx_left.png | ||
| + | |zurück=Libname Engine (from Fraktal SAS Programming) | ||
| + | |rechts=xx_right.png | ||
| + | |vorwärts=Passthru SQL (from Fraktal SAS Programming) | ||
| + | |hoch=Duck_zazy_com.png | ||
| + | |übersicht=DBMS Interaction (from Fraktal SAS Programming) | ||
| + | }} | ||
Version vom 30. Juni 2014, 14:41 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 |
select * from connection to oracle |
Start your query from inside SAS with a special from clause |
( select * from ops$&DB_USR..&MYTABLE. ) |
Inside brackets use DBMS specific SQL |
; |
Execute the query by issuing the SAS statement terminator ';' |
disconnect from oracle; |
Close connection to DBMS |
quit; |
Terminate SAS SQL interpreter status |
|
|
|
|
