topic Re: insert with accepting duplicates in Application Development and Automation Discussions

insert with accepting duplicates

Former Member — Thu, 22 Mar 2007 21:08:46 GMT

insert ztable from wa_ztable

how to add code to accept duplicates as well ?

Re: insert with accepting duplicates

Former Member — Thu, 22 Mar 2007 21:12:21 GMT

INSERT ztable FROM TABLE itab ACCEPTING DUPLICATE KEYS. All this does is that if there is an entry with a duplicate key, it will simply drop the record and the SY-DBCNT will give you the number of inserted records.

Re: insert with accepting duplicates

Former Member — Thu, 22 Mar 2007 21:13:34 GMT

Do not maintain any primary keys in your ztable.

INSERT command will insert a row if it does not find one with matching primary keys. If it finds it will not insert the row.

Thanks,

Santosh