Re: lock mode problem

Posted in 1996

David Williams — Mon, 25 Nov 1996 20:48:34 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <57c2qb$rn7@cssun.mathcs.emory.edu>, Billy Wheeler <billy@west.co.za> writes >On 25 Nov 96 at 10:25, peter_jennings@uk.ibm.com wrote: > >> How can we check any of this, and correct it? > >Can't remember how to check it (probably somewhere in systables), but >you can change it by saying ALTER TABLE x LOCK MODE (ROW); > >HTH. >-- >Ciao, > >Billy > >I'd be in favour of apathy, but I just couldn't be bothered... SELECT locK_level from systables where tabname = "<name of table>". "R" = row level locking "P" = page level locking. -- David Williams