Skip to Content
0
Former Member
Nov 14, 2006 at 06:00 AM

Performance between MODIFY / UPDATE

1454 Views

Dear SDN's,

I would like to know differences in usage of below statements.

  1. MODIFY <dbtab> FROM <wa>.

  2. UPDATE <dbtab>

SET <col> = <value>

WHERE <keycol> = <Keycolumn Value>.

The <dbtab> has been constantly updating through background job and as well thru' front-end.

Regards,

Ramki.