Perfomenec with update Set stamnt

[Former Member]

Hi ,

I am using the below in LOOP . But it is taking long time to update the data base. Can I use Modify instead of below code.

UPDATE MARC CLIENT SPECIFIED

SET ZC_LT = W_ZC_LT_F

ZT_LT = W_ZT_LT_F

WHERE mandt = sy-mandt

and MATNR = IT_STB-MATNR

AND WERKS = IT_STB-WERKS.

Here I am updating the MARC Table. I Used Locks also to over the issue. When ever Cursor come to the Update stamt it is going to be time out . Please advice me in this.

regards,

Ajay

Edited by: Ajay on Oct 8, 2008 4:40 PM

[Former Member]

This is the same problem you had earlier. In your first post I asked how many times the loop was being processed. Could you answer that please?

Rob

[karol_seman]

Hi Ajay,

try the following: Create internal table into which you store (in your actual loop) all the changes you need to perform. Then just use following code:

UPDATE (dbtabname) FROM TABLE itab.

so you will do all your updates after loop at once ...

Regards,

Karol