Skip to Content

Avoid deleted

Sep 29, 2017 at 02:54 PM


avatar image

Hi, I am trying to create a rule to avoid delete in target. I tried with code here but it is not clear for me what is the value for the line "ASSIGN (i_p1) to ...

Could you please explain


10 |10000 characters needed characters left characters exceeded

I changed the primary tag and published


(Unfortunately) SAP now has 2 products with 'Replication Server' in the name ... and there's no relationship between the two:

- SAP Landscape Transformation (SLT) Replication Server

- (formerly Sybase) SAP Replication Server

You've tagged your question with both products ... recommend you remove the tag that doesn't apply. [While I use (Sybase)SAP Replication Server, the terminology in your question doesn't sound familiar so I'm assuming you're using SLT Replication Server ... ??]

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joanna Zbytniewska Oct 17, 2017 at 12:58 PM

There are three triggers in source DB for each replicated table: for inser, update and delete.

You might drop the unwanted _DEL trigger or modify it in such way it does not insert the row for deletion into the logging table.

10 |10000 characters needed characters left characters exceeded
Andrey Martynov
Nov 06, 2017 at 04:05 PM

Please, don't delete any triggers. SLT server check every time the consistency of source system and can detect that you miss some of the triggers.
I don't understand your scenario. What do you want to do with deleted records - just skip or something else?

10 |10000 characters needed characters left characters exceeded