I am trying to use a similar features from MS whereby SP are being
use for Data Processing.

I have created a before insert trigger to generate a unique number
treated as the session number for Table A.
After numerous processing on Table B & C, the results were inserted
into Table A. Table A later are being manupulated before inserted
into Table D.

Since IB doesn't support Commit statement inside SP, The update
process from Table A to D cannot be seen.

Any help on this ?

Thanks

Sam