Ingres uses a value of NO WAIT for the timeout parameter in the SET LOCKMODE statement to indicate that when a lock request that is made that cannot be granted without incurring a wait, control is immediately returned to the application that issued the request. NO WAIT applies to any lock in a transaction or a lock on one or more specific tables. For more information, see the SQL Reference Guide and Database Administrator Guide.