Skip to Content
avatar image
Former Member

Perfomenec with update Set stamnt

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 08, 2008 at 06:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2008 at 06:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded