Lets you specify whether generated SQL is passed to the data source for processing.
Valid in: | LIBNAME statement |
Default: | YES |
Supports: | All |
specifies that generated SQL from PROC SQL is passed directly to the data source for processing.
specifies that generated SQL from PROC SQL is not passed to the data source for processing. This is the same as specifying the value NOGENSQL.
specifies that generated SQL is not passed to the data source for processing. This includes SQL that is generated from PROC SQL, as well as SAS functions that can be converted into DBMS functions, joins, and WHERE clauses.
prevents PROC SQL from generating SQL to be passed to the DBMS for processing.
prevents WHERE clauses from being passed to the data source for processing. This includes SAS WHERE clauses and PROC SQL generated or PROC SQL specified WHERE clauses.
prevents SQL statements from being passed to the data source for processing when they contain functions.
specifies that PROC SQL does not attempt to pass any multiple outer joins to the data source for processing. Other join statements might be passed down, however, including portions of a multiple outer join.
proc sql; create view work.v as select tab1.deptno, dname from mydblib.table1 tab1, mydblib.table2 tab2 where tab1.deptno=tab2.deptno using libname mydblib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=oradsn direct_sql=nogensql;
libname mydblib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=oradsn direct_sql=nofunctions; proc print data=mydblib.tab1; where lastname=soundex ('Paul'); run;