Update Sybase table with SAS/SQL

[6656]

How to solve below error message:
"ERROR: MEMBER level locking for UPDATE or RANDOM access is not supported by the engine."

Message from below program code:

libname mytest SYBASE user='abc' password=xxxxx
sever='xyz' database='mydbs';
porc sql;
update mytest.sybtable
set data_var_flag =1
where year='2002';
quit;

 

[6656]

Self Solution: using execute statement.