Control for "Isolation level" at SELECT statement level

[Hillel Eilat]

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.

[Jonathan Leffler]

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: [email]jleffler@earthlink.net[/email], [email]jleffler@us.ibm.com[/email]
Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

[Jean Sagi]

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
[email]jeansagi@myrealbox.com[/email]
[email]jeansagi@netscape.net[/email]

sending to informix-list