Can you explain more about why you need to 'commit'. As I understand
it, all actions are performed sequencially and therefore immediately
reflected in the stproc's 'view' of the data, e.g. if stm X inserts
ten records into a table, stm X+1 can read those records (am I wrong
here?).

Regards,
Andrew Ferguson

--- In ib-support@y..., "Sandeep" <sandeep@c...> wrote:
> How is work commited inside Stor Proc ?
>
> I want to do the following
>
> stm 1;
> stm 2;
> ...
> ...
> ...
> stm X;
> --------- commit work here ---
> stm X+1
> ...
> ...
>
>
> Regards
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@c...
> http://www.cfl.co.nz