The Microsoft
ODBC specification defines three levels of support for SQL grammar:
Minimum, Core, and Extended. The SAS ODBC Driver supports all Minimum-level
and some Core-level SQL statements and statement elements. For more
information about supported grammar, see
Base SAS Procedures
Guide.
Currently,
the SAS ODBC Driver does not support the following SQL syntax:
SELECT FOR UPDATE OF
Records are locked during data
manipulation operations, but cannot be explicitly locked before a
data manipulation operation.