RE: Informix Connect 2.80 and Isolation Levels
I have a stored procedure for users connecting over ODBC to set their
isolation level.
Regards,
Bill
create procedure "informix".dirtyread_proc()
returning int;
define global sql_err, isam_err int default 0;
define global err_text varchar(30) default null;
on exception set sql_err, isam_err, err_text
raise exception sql_err, isam_err, err_text;
end exception;
set isolation to dirty read;return 1;
END PROCEDURE;
> -----Original Message-----
> From: Dean Colter [SMTP:devodawg@yahoo.com]
> Sent: Thursday, May 22, 2003 12:01 PM
> To: informix-list@iiug.org
> Subject: Re: Informix Connect 2.80 and Isolation Levels
>
> asdfasanjas
> "Dean Colter" <devodawg@yahoo.com> wrote in message
> news:9P5za.628$0E2.101742@news20.bellglobal.com...
> > Does anyone know if there is a way to set the isolation level in the
> connect
> > string? Or is there a way to set this either by user or on the Informix
> > Client itself so that it is always default read uncommitted.
> >
> > I use an application that connects to databases. Problem is I can not
> set
> > the isolation level in the product. If I could set it either in the
> connect
> > string, in the client, or have an isolation level pre set per database
> user
> > I could force the isolation level I want by the query versus by the
> > database.
> >
> > Dean Colter
> >
> >
>