Re: Informix Connect 2.80 and Isolation Levels
I am not following where this is called. Could you
explain when / how this procedure is called. Is it in
their queries or odbc settings?
Andy
-----Original Message-----
From: Bill Dare [mailto:dareb@jevic.com]
Sent: Thursday, May 22, 2003 1:34 PM
To: 'Dean Colter'; informix-list@iiug.org
Subject: 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
> >
> >
>