Are you certain the commit is actually being issued? You may want to perform
a trace to make sure.
Ong Chin Hui wrote in message <35823eee.287898209_at_butler.psa>...
>On Sat, 13 Jun 1998 05:40:38 GMT, "rok" <rok_at_MCI2000.com> wrote:
>
>Thanks for responding
>
>1. Forget to mention one thing. I perform a commit after every
>update/insert in the select.
>
>ie.
> main()
> {
> select * from TABLE_A where processed_i = 0
>
> // process the records
>
> for each record
> {
> // processing of record
>
> start transaction
> update/insert TABLE_B
>
> // update record as processed
>
> if no error
> update TABLE_A set processed_i = 1
> commit transaction
> }
> }
>
>
Received on Tue Jun 16 1998 - 21:24:39 CDT
