Subject Re: [IBO] IB_Cursor commits automatic on Error
Author Guido Klapperich
> On the other hand, if your SP is executing some DML in addition to
> feeding out rows to the output buffer --- a highly NOT RECOMMENDED
> thing to do --- then you will have a genuine need to use Rollback to
> end the transaction.

Exactly, my SP executes some DML and after every DML command it does a
suspend to give a callback to the client. Why it is not recommended?

In my case a TIB_Query would be better as Alan suggested.

Regards

Guido