Re: Viewing existing lock mode

Wendy Alm (walm@icsware.com) wrote: : 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 SELECT tabname,locklevel FROM systables Locklevel will be: Page: B and P Row: R I'm not certain, but I would recommend using the "ALTER TABLE" statement to change these, rather than updating the table directly. Can anybody confirm whether there's a difference? Does something other than this column get changed? ie. a physical change to the tables? __________________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@uns-dv1.jcpenney.com 12700 Park Central Pl (214) 591-7543 Dallas TX 75251