Case study 24: Lock and hold
- Platform: All
- Sybase ASE version: 12.5.x and higher
- Background story: One of our developers need to test what would happen if he tries to access a table and the table is locked for some predefined time. These were tests for query timeout.
- Task: Write a query which is going to hold an exclusive lock on a table for some predefined time.
- Solution: Here is a query which is going to hold exclusive lock for some predefined time on a table table_name:
declare @var char(8)
select @var = "00:00:10" -- time in seconds(10 seconds)
lock table table_name in exclusive mode
waitfor delay @var