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)
Status	Dynamic
Display level	Comprehensive
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:

0 – the default value for select for update is 0.
1 – the default value for select for update is 1.

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.