> Are you familiar with the IBX.

Unfortunately yes.

> for example the query.transaction.commitretianing could only commit
> for the query only ... I have as this and Jason reply me that its
> counter part is savepoint. And when I went to the IBO help for the
> definition of savepoint its like is not what I need. Thanks for your
> clear explanation of the savepoint ... Does IBO has counter part on
> what I have mention IBX can do? without creating another transaction
> exclusively for that query?

Whatever IBX taught you about transactions, please forget.
The way Jeff implemented transactions was abhorrently poor in my opinion.

Jason