The LIBNAME Statement for Relational Databases |
Determines the method that is used to update and delete rows in
a data source.
Default value: |
YES (except for the Oracle drivers from
Microsoft and Oracle)
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Microsoft SQL Server, ODBC
|
-
YES
-
specifies that SAS/ACCESS uses
Current-of-Cursor SQL to update or delete rows in a table.
-
NO
-
specifies that SAS/ACCESS uses
the SQLSetPos() application programming interface (API) to update or delete
rows in a table.
This is the update/delete equivalent of
the INSERT_SQL= LIBNAME option. The default for the Oracle drivers from Microsoft
and Oracle is NO because these drivers do not support Current-Of-Cursor operations.
To apply this option to an
individual data set, see
the
UPDATE_SQL= Data Set Option.
INSERT_SQL= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.