Passthru SQL (from Fraktal SAS Programming): Unterschied zwischen den Versionen

Version vom 30. Juni 2014, 17:24 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	Start coding a passthru SQL code segment
(	Open passthru SQL channel using a left bracket
create table my_ora_tab as select * from ops$&DB_USR..&MYTABLE.	Type your Oracle SQL code as if you were using some Oracle client or frontend
)	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

@@ Zeile 24: / Zeile 24: @@
 |
   execute
-| '''Trigger execution of passthru code by the SAS SQL interpreter'''
+| '''Start coding a passthru SQL code segment'''
 |-
 |
@@ Zeile 32: / Zeile 32: @@
 |
   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'''
+| '''Type your Oracle SQL code as if you were using some Oracle client or frontend'''
 |-
 |