Fwd: RE: lock mode

Keith, et al, Lock mode 'B' is used for Views primarily it means 'Both' or indeterminate. The Syntax manual for 9.3 says 'B' is Page Mode also for the system tables that use it I suppose. Art S. Kagel David Select locklevel from systables where tabname = "your_table" R = Row P = Page ? B = System Table ? null = Version Identifier Keith -> -----Original Message----- -> From: WU DAVID [mailto:tkwwpicc@cta.cq.cn] -> Sent: Thursday, March 06, 2003 8:22 AM -> To: ids@iiug.org -> Subject: lock mode [608] -> -> -> hi everyone, -> How can I tell which lock mode of the database table is? -> -> IDS 7.31 -> AIX 4.3.3 -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **