Re: Table locking in Informix table..

Operating System: HP-UX B.10.01 A X-Mailer: Elm [revision: 111.1] } } 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 } --------------------------------------------------------- } You need to set your isolation level to repeatable read. This will allow the first process to gain a lock on the rows for which 'dept no' is 10 and the second process will be able to get a shared lock on these rows, but not get an exclusive lock. -- Scott Hanson Junior Consultant scott@worldaccess.nl NexTime B.V. Database & O/S Technology work: (31) 10 207 5400