| |
GeekInterview.com > Interview Questions > Database > Sybase
| Print | |
Question: Locking in Sybase
Answer: What is Locking in Sybase? What are its types? |
| November 11, 2008 23:02:38 |
#2 |
| dhampack |
Member Since: November 2008 Total Comments: 6 |
RE: Locking in Sybase
|
Sybase does support locking at row level in version 12.5 onwards.
Sybase use locking in below modes
- Shared
- Exclusive
- Update
For APL(all page locking), sybase locks data as well index page
For DOL(data only locks) either row level or data page level, sybase use not transactional locking(latches) |
| |
Back To Question | |
