Hello,

> The way you accomplish this is use the FOR UPDATE clause with your select
> statement. This tells the engine to only send a single record at a time
> from
> the server. Otherwise, by default, it will pull in enough records to fill a
> network packet so that more efficient use of your bandwidth.
>
> Be sure to watch in the SQL trace monitor to see if that clause remains. I
> suggest only using the TIB_Cursor component for these queries because it is
> unidirectional and not buffered.

Just adding FOR UPDATE didn't help. I haven't looked more on the "why",
because TIB_Cursor just did the job.
Thank you for your help.

--
Aurimas