topic Re: Query regarding UPDATE in Application Development and Automation Discussions

Query regarding UPDATE

Former Member — Tue, 26 Jun 2007 10:46:55 GMT

Hi All,

I have one query regarding UPDATE.

If I want to update only one field of a database table from my internal table..what is preferable & Why in terms of performance, standards ?

(1) Loop at internal table. update the database table with SET statment.

Problem: Multiple database touch.

(2) update the database table with internal table at one go, with use of UPDATE statement.

Problem: I am updating all fields even if I want to update only one field.

Regards,

Siddhesh Sanghvi.

Re: Query regarding UPDATE

former_member404244 — Tue, 26 Jun 2007 10:49:51 GMT

Hi,

Instead of UPDATE use MODIFY statement.Now this statement will modify only the field u required.

Regards,

Nagaraj

Re: Query regarding UPDATE

Former Member — Tue, 26 Jun 2007 10:50:03 GMT

First fetch the data from DB table into internal table

loop that itab.

modify that field in itab

endloop.

use modify statement to update the db table

MODIFY DB from table ITAB.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Query regarding UPDATE

Former Member — Tue, 26 Jun 2007 10:50:41 GMT

It is preferred to loop at internal table and update the table field.

Loop at itab.

Update TABLE <table> set field = value..... where <condition>

Endloop.

<b>Second option is not preferred</b>.

Regards

Raj

Re: Query regarding UPDATE

Former Member — Tue, 26 Jun 2007 10:53:50 GMT

Hi Siddhesh,

In case of UPDATE statement it is always advisable to UPDATE the data at one go itself, rather than making it inside the loop.

However, when you want to update any of the primary key fields of the database table, you will always have to use the UPDATE with SET addition inside a loop.

So, basically, your problem depends on the requirement. Please see if you can use the UPDATE at one go depending on the fields to be updated.

Re: Query regarding UPDATE

Former Member — Tue, 26 Jun 2007 11:00:51 GMT

Hi...

Use Modify statement to update the database table by putting that statement in loop throught proper condition.

Regards

Sasidhar Reddy Matli.