How do I get the duplicated entries when using INSERT dtab FROM itab.

Question

Hello,

I was wondering if, when using a try-catch command, you can get the duplicated entries from the exception class cx sy open sql db

Answer 1

1

I think you can do it with something like this

try.
  insert sometable from table my_itab.
catch cx_sy_open_sql_db into oref.
  if oref->textid = oref->duplicate_key.
    "do something
  endif.
endtry.

permanent link

answered 17 Sep '12, 16:52

pvl
137●3●5●10
accept rate: 33%

This checks if the dump occured due to duplicated keys, it is useful but not what I'm looking for. I was wondering if there was something like a method to return a internal table with the duplicated keys from that object.

(18 Sep '12, 07:32) Fawcs

How do I get the duplicated entries when using INSERT dtab FROM itab.

Follow this question

Related questions