Using SQL replication via Replication Server:
Is it possible, from an After Insert trigger on a target table, to delete the corresponding row from the non-DB2 source table?
The source table is on an MS SQL server.
The target is on the federated server and has an After Insert trigger that calls an external procedure on an i5 server.
On return from the procedure, we want to delete the original row in the source table on the MS SQL server.
Everything works fine with the trigger through the call to the stored procedure, which processes as intended & returns a parameter.
How can we delete the row from the source table on the MS SQL server?
We can't do it via the fed nickname, because a nickname can't be updated in a trigger. We figured we could use SET PASSTHRU to connect to the MS SQL server, but that's not an allowable SQL statement in a trigger body.
Any way to accomplish this?
This topic has been locked.
2 replies Latest Post - 2010-01-05T20:44:23Z by SystemAdmin
Pinned topic Delete replication source via After Insert trigger on replication target
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-01-05T20:44:23Z at 2010-01-05T20:44:23Z by SystemAdmin
RichieEscarez 270000WWFW2 PostsACCEPTED ANSWER
Re: Delete replication source via After Insert trigger on replication target2010-01-05T18:43:33Z in response to SystemAdminHi Will,
I had the Federation development team review your question and they concluded that it is not possible and there is no alternative way to perform operations on nicknames via triggers.
IBM InfoSphere Federation Server