Re: view table

ANTS wrote: > > Dear Listers: > > We have a master employee table with thousands of records. Whenever a > department updates its records it will lock other ppl records as well ( we > are using the default page level locking). What's the best way to handle > these updates, BTW, this kind of updates can be several time per day. > > For view table, when updating a view table, will the base table be locked as > well. I guess so, but want to make sure, cause one of the programmers > suggested using view tables. > > Thanks in advance.. > > Nien > > =========================================== > Mails are checked daily and processed right away. > If you don't get my replies within 3 days please send your mail again. Yes, the base table will be locked if you access it through a view. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/