If this is UniData, we fixed a problem in this area at 6.1.7 (released 3/18/05):
Issue 6917 - Problem Description
UniData -- A lock release in SQL UPDATE failed, causing SQL to hold the
locks for records that were excluded from the query with a WHERE clause.
A fix to the lock checking utility corrected this issue.
Wally Terhune
SWG Client Support - Information
Management Software
U2 Support Architect b IBM U2
Client Support Team
4700 S. Syracuse St., Denver, CO
80237
Tel: (303) 773-7969 T/L
656-7969
Mobile: (303) 807-6222
[EMAIL PROTECTED]
Register today for the premier
U2 technical event!
Pamela J Robbins
<[EMAIL PROTECTED]
nn.edu> To
Sent by: u2-users@listserver.u2ug.org,
[EMAIL PROTECTED] "Cattanea, Tom"
stserver.u2ug.org <[EMAIL PROTECTED]>, Chris
Dunbar <[EMAIL PROTECTED]>
cc
08/27/2007 09:32
AM Subject
[U2] SQL query locks
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
Hi,
We have a Cold Fusion app that is using SQL queries. It's locking
records, unfortunately as many as 100 at a time. Is there a way to do
the query without locking records? We're not updating anything.
Pam
--
Pamela J Robbins New Bolton Center
Senior Programmer Analyst School of Veterinary Medicine
[EMAIL PROTECTED] University of Pennsylvania
610-925-6438
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/jpeg which had a name of
11186367.jpg]
[demime 1.01d removed an attachment of type image/jpeg which had a name of
11145374.jpg]
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic29259.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
