The Microsoft
ODBC specification defines three levels of support for SQL grammar:
Minimum, Core, and Extended. The drivers support 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 drivers
do 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.