Table locking in Informix table..

Hi, I have the follwing question on table locking feature of Informix table. Please let me know if you have answer to this. We want to implement table locking. Suppose, there is a table "my_table", which has the following fields. dept_no integer (NOT UNIQUE) dept_name char[20] no_of_people integer There are following rows in the table. Dept. NoDept. Nameno_of_people. 10 STS 10 10 STS1 20 20 HRD1 5 20 HRD2 4 30 Security15 30 Security23 Can I have multiplerecord level locking to the above table ? i.e. If a process locks the records for which "dept no" is "10",(i.e. 1st and 2nd record, in the above table) the second process must not be allowed to see either of 1st or 2nd record. However the 2nd process should be able to see records other than record 1 and record 2. If the record level locking is possible, please advise how do I implement ? Informix version I am using is INFORMIX Online 7.1 Ravi Hubbly Ravi.Hubbly@autozone.com --------------------------------------------------------- Get Your *Web-Based* Free Email at http://www.hotmail.com ---------------------------------------------------------