Path: utzoo!attcan!uunet!samsung!noose.ecn.purdue.edu!iuvax!att!drutx!rlp
From: rlp@drutx.ATT.COM (Bob Prehn (@ The Right Choice))
Newsgroups: comp.databases
Subject: Ingres Endretrieve problems
Keywords: UTS, KnReqLock, RTI no help
Message-ID: <5394@drutx.ATT.COM>
Date: 6 Apr 90 05:19:23 GMT
Distribution: comp
Organization: AT&T Bell Laboratories - Denver
Lines: 26


We have had a problem using ENDRETRIEVE or ENDLOOP statements in EQUEL/C
Over the last 4 years!
RTI has been asked several times (both local and California) about this problem.But they have never done anything about it.


We have a number of situations that have only one match for a given search
and we want to terminate the search.  (Some instances of having many allowable
values and we only want the first one.)  The problem is that the next Ingres
statement dies with an KnReqLock or KnClrLock errors along with 9900 end of
file messages.  The exact spelling of the errors may be different, since
it has been a while since I saw the message.  (It is still a problem today,
Others in my group have had the problem.)  The work-around is to not use the
endretrieve and suffer the performance penalty.

Is there soemthing else that can be done?  I am tired of RTI's inaction!

 Robert Prehn      +-----------------------------------------------------------+
 AT&T Bell Labs    |     ____   _______   _____   _______                      |
 Room  1E25        |    / __ \ |__   __| /   _ \ |__   __|                     |
 11900 North Pecos |   | <__> |   | |    \  \ \_\   | |                        |
 Denver, Co  80234 |   |  __  |   | |    /   \ __   | |    THE           CHOICE|
        	   |   | |  | |   | |   |  (\ / /   | |                        |
 drutx!rlp         |   |_|  |_|   |_|    \_____/    |_|                        |
 (303) 538-4554    |                                                           |
                   +-----------------------------------------------------------+