[Info-ingres] is there a way of checking that the lockmode has been set?

[Roy Hann]

Allan Biggs wrote:

> I later discovered  (for windows)
>
> SET ING_SET=SET LOCKMODE SESSION WHERE READLOCK=NOLOCK 
> and 
> SET ING_SET_node1::db_allan =SET LOCKMODE SESSION WHERE READLOCK=NOLOCK 
>
> I was just surprised that "::" is OK in the environment variable 
> Is there a way of checking that the lockmode has been set in the 
> ingres_net database? 

As in a dbmsinfo() call? No.

Probably the best thing you can do is connect using sql or isql, SET
LOCK_TRACE and try some stuff to see what happens. 

If sql picks up the setting then your application will too.

Roy

PS: Rather than twiddle lockmodes I'd be inclined to set the session
isolation level to read uncommitted. That has the benefit that it makes
the session read-only, which is prudent when you can't be confident of
what you're being shown in the database.