Subject Re: set transaction
Author csswa
Hi Antonio.

I don't think IBConsole allows you to alter transaction params.

You need to use ISQL, connect to db, and set the transaction params*,
or use a tool like IBExpert which contains options for specifying
transaction params. You can also set isolation level in IB_SQL.
Common thread: use something other than IBConsole.

* e.g. SET TRANSACTION WAIT ISOLATION LEVEL READ COMMITTED;

Regards,
Andrew Ferguson
-- I grease the wheels and fleece the squirrels.


--- In ib-support@y..., Antonio Natividad <locosoft_lnx@y...> wrote:
> Hi:
>
> How can I change the transaction behavior from my IB
> Console?....I'm trying with this sentence:
>
> set transaction WAIT isolation level read committed
>
> but I got this message "Not permitted
> Statement:"
>
> Thanks
>
> Regards
>
> _________________________________________________________
> Do You Yahoo!?
> La emociĆ³n e intensidad del deporte en Yahoo! Deportes.
http://deportes.yahoo.com.mx