I tried to use LIBNAME and PROC SQL to insert a row into an existing DBMS
table. I got error:
ERROR: MEMBER level locking for UPDATE or RANDOM access is not supported
by this engine.
ERROR: PROC SQL could not undo this statement if an ERROR were to happen
as it could not obtain
exclusive access to the dataset. This statement will not execute as
the SQL option
UNDO_POLICY=REQUIRED is in effect.