Sybase does support locking at row level in version 12.5 onwards.Sybase use locking in below modes- Shared- Exclusive- UpdateFor APL(all page locking), sybase locks data as well index pageFor DOL(data only locks) either row level or data page level, sybase use not transactional locking(latches)
Lock: controling access to page In sybase, locking is done at page level (whereas in Oracle, it is at row level).So, suppose if we have a lock (shared lock, write lock) on a page, than we can not access any rows in that page.