The LIBNAME Statement for Relational Databases DIRECT_SQL= LIBNAME Option 99
YES
specifies that SAS/ACCESS processing continues if multiple rows are deleted. This
may produce unexpected results.
NO
specifies that SAS/ACCESS processing does not continue if multiple rows are deleted.
Details
Some providers do not handle the following DBMS SQL statement well and, therefore,
delete more than the current row with this statement:
DELETE ... WHERE CURRENT OF CURSOR
DIRECT_SQL= LIBNAME Option
Enables you to specify whether generated SQL is passed to the DBMS for processing
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle,
Microsoft SQL Server, SYBASE, Teradata
Default value: YES
Syntax
DIRECT_SQL= YES | NO | NONE | NOGENSQL | NOWHERE |NOFUNCTIONS
|NOMULTOUTJOINS
Syntax Description
YES
specifies that generated SQL from PROC SQL is passed directly to the DBMS for
processing.
NO
specifies that generated SQL from PROC SQL is not passed to the DBMS for
processing. This is the same as specifying the value NOGENSQL.
NONE
specifies that generated SQL is not passed to the DBMS for processing. This includes
SQL that is generated from PROC SQL, SAS functions that can be converted into
DBMS functions, joins, and WHERE clauses.
NOGENSQL
prevents PROC SQL from generating SQL to be passed to the DBMS for processing.
NOWHERE
prevents the WHERE clause from being passed to the DBMS for processing. This
includes the SAS WHERE clause and the PROC SQL generated or PROC SQL
specified WHERE clause.
NOFUNCTIONS
