Re: Setting Isolation Level

"Jonathan Leffler" <jleffler.iiug@xxxxxxxxx> wrote in message
news:mailman.381.1138862999.740.informix-list@xxxxxxxxxxx
>
> On 2/1/06, Ekstrand, Pam <Pam.Ekstrand@xxxxxxxxxxx> wrote:
> >
> > I have an IDS 9.40FC6 database which receives queries from Sql Server
> > 2000's OpenQuery functionality.  OpenQuery will only pass one select
> > statement, sothe "set isolation to dirty read" cannot be passed
> > followed by another select statement.
> >
> > Does anyone have any ideas of how I can set the isolation level to
> > dirty read in any other way?  All sessions that connect as a specific
> > user id to a given database need to have the isolation level set to
> > dirty read. Any ideas would be greatly appreciated.
>
> Several options - some of them currently work.
>
> <SNIP>
>
> 2.  Create and execute a stored procedure which sets the isolation,
> runs the query and returns the data.  This depends on you being able
> to run an EXECUTE PROCEDURE statement via your OpenQuery tool.
>
> <SNIP>

I have just tested this OK on an SQL Server instance with a link to an
Informix database:

  SELECT * FROM OPENQUERY (linked-server-name, 'execute procedure ...')

So, do as Jonathan says using WITH RESUME to return multiple rows from
the stored procedure. This the easiest of the suggested options.

-- 
Regards,
Doug Lawry
www.douglawry.webhop.org


.

Relevant Pages

  • Re: change default isolation level on sql server 2005
    ... Have you actually set the database to Read_only? ... I believe SQL Server does some internal optimizations if it knows there will never be contention. ... I am also sure that there would be no way to change default isolation level ... "Kalen Delaney" wrote: ...
    (microsoft.public.sqlserver.programming)
  • Re: ReadCommited means?
    ... ReadCommitted is the default isolation level for SQL Server. ... to the database. ... Please clarify this. ...
    (microsoft.public.data.oledb)
  • Re: change default isolation level on sql server 2005
    ... I am also sure that there would be no way to change default isolation level ... The database is only SELECT so that's why they would ... Our team would like to change default isolation level on sql server 2005 ... I see books online stating that the default isolation level is read ...
    (microsoft.public.sqlserver.programming)
  • change default isolation level on sql server 2005
    ... Our team would like to change default isolation level on sql server 2005 ... set TRANSACTION ISOLATION LEVEL on every stored procedures or set any data ... isolation level information on one database (not DBCC USEROPTIONS because it ...
    (microsoft.public.sqlserver.programming)
  • SQLite (with APSW) and transaction separate
    ... I want to use SQLite database like the FireBird database: ... transaction too, with same style. ... If ISOLATION LEVEL is low, the report can see the new subitems of the ...
    (comp.lang.python)