Re: Q: Lock Detection in Pro*C / V7 (long message)
From: GeraldJ117 <geraldj117_at_aol.com>
Date: 6 Oct 1994 15:50:01 -0400
Message-ID: <371kd9$9t7_at_newsbf01.news.aol.com>
Date: 6 Oct 1994 15:50:01 -0400
Message-ID: <371kd9$9t7_at_newsbf01.news.aol.com>
We have had to do the same thing. Add "NOWAIT" to the end of your embedded query, and the system will return -54 if the record is locked.
ie
Select x from y nowait;
or
update x
set y = z nowait;
Jerry J.
Reengieering Consulting
Received on Thu Oct 06 1994 - 20:50:01 CET