topic Re: Row by row update in Application Development and Automation Discussions

Row by row update

Former Member — Mon, 21 Dec 2009 12:33:12 GMT

<<stop posting your interview questions>>

The below select statement is taking too much time in Production system,

is there any way to optimize the above code ?

"select * from VVBAP

into g_wa_vvbap

where vbeln in g_vbeln.

g_wa_vvbap-zmeng = g_wa_vvbap-zmeng + 5.

update vvbap from g_wa_vvbap.

Endselect."

Sandeep

Edited by: Matt on Dec 21, 2009 2:10 PM

Re: Row by row update

ThomasZloch — Mon, 21 Dec 2009 12:37:57 GMT

The code is below, not above. For you, that is. For me, it is above, not below. Hope you understand.

Thomas

Re: Row by row update

Former Member — Mon, 21 Dec 2009 15:03:53 GMT

Looks like Subin is trying to divert attention and you just won the lotto..

Re: Row by row update

ThomasZloch — Mon, 21 Dec 2009 15:22:20 GMT

You're right, looks like I got two tenners from Sandeep already...please contact me before taking action.

Thomas

Re: Row by row update

Former Member — Tue, 22 Dec 2009 15:53:16 GMT

Hi Thomas,

Reading this was a real treat

The code is below, not above. For you, that is. For me, it is above, not below. Hope you understand.

My experience ..

I searched for the answer so that i may be the early bird to post the answer,on this thread..and win some good points on this thread...

I felt bad that day that in spite of my efforts, Sandeep gave 10 points to Subin.

Now i see it all

Am feeling a looooooooooottttttttt better now.

Sandeep,Subin,Vicky... lesson to be learnt

Regards,

SuryaD.

Re: Row by row update

Former Member — Tue, 22 Dec 2009 16:02:10 GMT

Yes, unfairness is often a horrible by-product of dishonest bias.

Subin's user ID will be deleted, along with his clones.

Cheers,

Julius

Re: Row by row update

Former Member — Tue, 22 Dec 2009 16:10:22 GMT

Regards,

SuryaD.

Re: Row by row update

Former Member — Tue, 22 Dec 2009 16:13:30 GMT

But you can still read the forum rules anyway, because Rob is still around...

Cheers and merry christmas,

Julius