Re: lock mode problem

Hi all, We've also seen "N" in the locking column. Does anyone know what this stands for? -Bill } } 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 } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com