Re: Set transaction isolation level read unco

>Is it possible in Informix to set the transaction isolation level >of a read-only transaction to read uncommitted, so that the >transaction sees the uncommitted writes of other ongoing transactions? >(In Oracle I have found that it is not possible.) Use the following: SET ISOLATION TO DIRTY READ There are acutally 4 different isolation levels. If you check your Informix-SQL Tutorial, there is a good discussion about them. J. Dority