|
>From: steven.donnellan@simonjersey.com [mailto:steven.donnellan@simonjersey.com] >...it causes locks in our Despatch Area as Query Optimiser does it's stuff. Is this with a RUNQRY or a WRKQRY? RUNQRY shouldn't lock up more that a SHRRD lock. However, WRKQRY may require a SHRNUPD lock at times. Take a look at http://archive.midrange.com/midrange-l/200207/msg01240.html for something that may help. -Walden ------------ Walden H Leverich III President Tech Software (516) 627-3800 x11 (208) 692-3308 eFax WaldenL@TechSoftInc.com http://www.TechSoftInc.com Quiquid latine dictum sit altum viditur. (Whatever is said in Latin seems profound.)
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
