topic UPDATE SQL table - most better? in Application Development and Automation Discussions

UPDATE SQL table - most better?

Former Member — Tue, 04 Dec 2007 18:22:28 GMT

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

insert every row to database in process of LOOP

Re: UPDATE SQL table - most better?

Former Member — Tue, 04 Dec 2007 18:35:10 GMT

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

Re: UPDATE SQL table - most better?

former_member194669 — Tue, 04 Dec 2007 18:37:08 GMT

Hi,

Use Modify


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

Note: please donot forget give commit work

a®