Re: Commit in SQR

[Prasanna Menta <pmenta@UMUC.EDU>]

If you think commit is the problem, you can give an explicit commit by
initialising a counter, say if 50 transactions have been processed then
do the commit, if you send the code it will be helpful to address the
problem, i do not think that commit makes the program to loop
Thanks
Prasanna

razeel zaleel wrote:
>
> Hi Guys,
>
> i am trying to COMMIT before the SQR ends that is in
> between i am selecting some records on certain
> condition then i update and COMMIT
> but the program goes into infinite loop
>
> any help
>
> Thanks in advance
> khan
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com