Hybrid Queries (from Fraktal SAS Programming): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K |
K |
||
Zeile 1: | Zeile 1: | ||
[[Kategorie:Zazy]] | [[Kategorie:Zazy]] | ||
− | + | ;1st Make SAS your SQL interpreter | |
proc sql; | proc sql; | ||
− | + | ;2nd Connect to the DBMS using your credentials stored in [[Macro Variables]] | |
connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH."); | connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH."); |
Version vom 21. Mai 2014, 11:43 Uhr
- 1st Make SAS your SQL interpreter
proc sql;
- 2nd Connect to the DBMS using your credentials stored in Macro Variables
connect to oracle (user="&DB_USR." password="&DB_PWD." path="&DB_PTH.");
- 3rd Start your query from inside SAS with a special from clause
select * from connection to oracle
- 4th Inside brackets use DBMS specific SQL
( select * from ops$&DB_USR..&MYTABLE. )
- 5th Execute the query by issuing the SAS statement terminator ';'
;
- 6th Terminate connection to DBMS
disconnect to oracle;
- 7th Terminate SAS SQL processor status
quit;