AIX Sybase Can i lock a record? (using C)

[ronenhm]

I have been told that it is not possible using the C programming
language to lock a record (one single entry on a table) in a database
such as Sybase. Is this correct? I find it hard to believe. Do you guys
know of a way?

 

[grega]

Can't comment on the C aspect, but Sybase introduced row-level locking with version 11.9.x of Adaptive Server. Previously, only page locking was available.

Greg.

 

[ghwin]

You can't prior to version 11.9.x. You should be able to now.

To lock a single record in Sybase, you'll need to set up the table for row-level lock type first.

To access this from C, you will need the Open-Client Libraries. This I've never tried, but it is possible.

- Greg Hwin