ibcQuery, ibcSQL with ReadOnly Transaction

[VICcus]

Hi!

In generally I change the ibcTransactions params from ReadCommited to ReadOnlyReadCommited in my application for ibcQuery and ibcSQL.

If the sql contain insert / update, its not a readonly query. Ok.
But what's happen, when the sql contain DML statement, such as Alter Table, Set Statistics, ... ?

Thanks in advance.

[VICcus]

Correction: DDL of course.

[ViktorV]

On attempt to execute DDL statements within the context of ReadOnlyReadCommited transaction, an error "attempted update during read-only transaction" will be generated.

[VICcus]

OK, thanks.

[ViktorV]

If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.