> Bind the source query to a txn with isolation tiConcurrency

and bind the

> target query to a transaction with isolation tiCommitRetaining.

Start the

> two txns, do your procedure and commit the txns.
> Hints:
> - TIB_Datapump is for those tasks but in this case you can fall in

the same

> loop
> - Maybe you will go slightly faster replacing the target query by a

TIB_DSQL

> component.

Thanks very much for help, it worked a treat.