Re: SQL statement Scope
>From: hhong@nova.umd.edu (hth)
>Subject: SQL statement Scope
>Date: 27 Jul 1994 15:07:43 -0400
>X-Informix-List-Id: <news.7847>
>What is the scope of set isolation and set lock mode statement in .ec
>files. Is it gonna be within the file, function, or entire program?
> void set_dbopt(voi)
> {
> $ set isolation to dirty read;
> $ set lock mode to wait 15;
> }
> {
> $ update .....
> }
> Would dirty read isolation, and lock mode wait be carried over to the
> update statment?
The ISOLATION and LOCK MODE are in force from the time when the statement
is executed until a new mode is set. With a single database in use, there
are no implicit mode changes; if you close the current database and open a
new one, then the modes will be changed to the default for that database:
UNLOGGED DIRTY READ
LOGGED COMMITTED READ
MODE ANSI REPEATABLE READ
The lock mode changes to NOT WAIT for all cases.
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>