Re: Viewing existing lock mode -Reply

In 7.x run dbschema on the table with the -ss option or you can also look it up in the system catalogue (systables.locklevel). I don't know if this works in 5.x rgds -- -- Peter Tashkoff NZ Kiwifruit Project Consultant/DBA Marketing Board. Standard Disclaimers apply This posting may not be used by any commercial organisation to vilify another. >>> <ANISHA_VASWANI@HP-SanJose-om1.om.hp.com> 25/July/1996 01:08pm >>> Item Subject: Viewing existing lock mode Hi, I was also wrestling with the same problem below -- I'd like to know what granularity of locking is currently being used. We're running On-line version 7.12. Any help would be much appreciated. Thx Anisha anisha_vaswani@hp.com ______________________________ Reply Separator _________________________________ Subject: Viewing existing lock mode Author: Non-HP-informix-list-owner (informix-list-owner@rmy.emory.edu) at HP-Boise,shargw4 Date: 7/24/96 2:55 PM 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