using qlik replicate where target endpoint has RI defined (DB2)

[ArntJohan]

Hi !

I am strugling replicating changes to a DB2 target endpoint where RI rules are defined.  Error message NativeError: -532
qlik trying to delete a row on mother tabel where the row exist in child table.... so it's not allowed according to RI rules set.

I am using transactional apply.

Is there a way I can ensure qlik does the delete (in this case) in the correct order.... first child and to mother table ?

Or is it not possible to use qlik replicate in combination with RI on target endpoint ?

Thanks

Arnt Johan Opheim
 

[john_wang · Accepted solution]

Hello @ArntJohan ,

Welcome to Qlik Community forum and thanks for reaching out here!

It looks to me the transactional apply mode in Qlik Replicate does not help, unless the source DB side changes meet the target side RI Definition. There is a good article define DELETE CASCADE on the foreign key table, hope it helps.

Regards,

John.

[ArntJohan · Accepted solution]

Thank's John !

BR

Arnt Johan