select for update

select for update enables SAP ASE to exclusively lock rows for subsequent updates within the same transaction, and for updatable cursors, preventing other concurrent tasks from updating these rows and from blocking the subsequent update.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1(on)



Display level


Required role

System administrator

Configuration group

Application Functionality

See Transact-SQL Users Guide > Queries: Selecting Data from a Table.

Note: The default value for select for update depends on the value to which enable functionality group is set. If you set enable functionality group to:

However, if you set select for update to 1, it uses a value of 1 regardless of what you set enable functionality group to.

See enable functionality group.