Control for "Isolation level" at SELECT statement level

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.

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. Which RDBMS? It isn't Oracle - the same question was asked in c.d.oracle.servers with only a change in the penultimate line of text. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/