Re: Control for "Isolation level" at SELECT statement level

In informix is: set isolation to dirty read; select... ... ; Hillel Eilat wrote: > Hi folks. > > Some RDBMS products support the following syntax format: > > SELECT .... <whatever...> WITH {READCOMMITTED | REPEATABLEREAD | ... > |SERIALIZABLE} > > The WITH clause provides the means for overriding the default isolation > level (or the one specified upon SET TRANSACTION) at a specific SELECT > statement. > > WITH clause is applicable for INSERT,UPDATE,DELETE as well. > > Is there an equvalent to the "WITH" clause in INFORMIX's SQL? > > > Your answers will be appreciated. > > > > Hillel. > > > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list