UPDATE SQL table - most better?

[Former Member]

Hi

I have internal table with many records, about thousands and I want to all this

record insert to database.

What is better:

UPDATE ztable from itab

or

insert every row to database in process of LOOP

[Former Member]

The answer is:

It depends.

In general, it's best to update from the internal table (faster); however, if you have a large number of records, you may dump if the rollback area is filled. You can get around this by updating in chunks.

But it also depends on what you think a logical unit of work is. It will depend on whether or not the whole process should fail if any records fail to insert.

Rob

[former_member194669]

Hi,

Use Modify

modify <your table> from table <your internal table>.

Note: please donot forget give commit work

a®