Data Set Options for Relational Databases |
Determines which method to use to update and delete rows in a
data source.
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
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() API to update or delete rows in a table.
This is the update and delete equivalent of the INSERT_SQL=
data set option.
To assign this option to a group of relational DBMS tables
or views, see the
UPDATE_SQL= LIBNAME Option.
INSERT_SQL= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.