Table timeouts

ggastelu@bnr.ca on 09/10/97 09:54:52 AM

> I send an SQL command to the ingres database on a locked
> table.  The process will wait indefinitely until the table is unlocked.
> Is there a way that a timeout can be added so I don't have to wait
> until the table becomes unlocked?

George,

You want to use the set lockmode command with the timeout option.
For example:

set lockmode on emptable where level = page, timeout = 10;

This will cause the process to wait 10 seconds for the desired page
to be unlocked.  After 10 seconds the statement will fail.  You'll have
to trap this condition.

__________
Bill Hoelzer  -> SCT Manufacturing & Distribution Systems ->
bhoelzer@sctcorp.com
Ingres Q & A
Back to William's Home Page
Email William