topic UPDATE dbtable FROM TABLE itab . in Application Development and Automation Discussions

UPDATE dbtable FROM TABLE itab .

Former Member — Tue, 27 Jun 2006 18:46:46 GMT

Hi All,

UPDATE dbtable FROM TABLE itab.

For the above statement, if there are entries in itab that do not have primary key in dbtable, then are they created in the dbtable or ignored.

if they are ignored, how would i know which are ignored. or how to insert those ignored lines into the dbtable.

Thanks in advance..!

RichHeilman — Tue, 27 Jun 2006 18:48:06 GMT

MODIFY will update current records and create ones that do not exists. Not sure about UPDATE as I never use it.


MODIFY dbtable FROM TABLE itab.

Regards,

Rich Heilman

Former Member — Tue, 27 Jun 2006 18:49:45 GMT

Thanks rich..!