Perfomenec with update Set stamnt
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.
Edited by: Ajay on Oct 8, 2008 4:40 PM