Re: Isolation level and ODBC

Richard Spitz wrote: > > Hi Informixers, > > in the c.d.i. archives, I found several statements that the isolation > level could be set via ODBC through a SQL passthrough statement with > the proper command "set isolation to <...>". > > What is the scope of this statement? I have a VB6 program that accesses > an IDS 7.3 database via ODBC (Intersolv 3.11, the one that ships with > IDS). There are triggers defined on some of the tables which will start > a stored procedure which in turn will run an ESQL/C program on the database > server via the "system" command. Will the isolation level defined in the > VB program be valid for this complete process? Isolation levels are session scope so they will affect the trigger and any stored procedures it executes but will have no effect on the ESQL/C program which will have to contain its own SET ISOLATION TO statement. > Is there an alternative for setting the isolation level via this ODBC > driver? No. Art S. Kagel