topic Re: using qlik replicate where target endpoint has RI defined (DB2) in Qlik Replicate

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

ArntJohan — Thu, 09 Nov 2023 09:16:01 GMT

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

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

john_wang — Thu, 09 Nov 2023 13:28:21 GMT

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.

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

ArntJohan — Fri, 10 Nov 2023 08:16:32 GMT

Thank's John !

Arnt Johan