Viewing existing lock mode
Posted in 1996
>
> We are trying to find out if a table in the database has row, table or
> page locking. We are running with on-line version 5.02. Is there
> anyway we can look this up on the current database? Thanks for your
> help in advance.
>
> Wendy
> walm@icsware.com
>
>
Try:
Select tabname, locklevel from systables where tabid > 99;
cheers
j.
_____________________________________________________________________________
Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA
jparker@boi.hp.com Currently on loan to PLD/PE
_____________________________________________________________________________
If anything can go wrong, fix it. To hell with Murphy.
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________