Hi
I have created the federated db and wrote trigger to enforce referential integrity thru trigger for updation and insertion. Now my need is if i delete the row in one table whixh is in databaseA, it should delete the child rows in yable resides in databaseB.
Pls help me in this issue. I will give the trigger which is worked for insertion here,
CREATE TRIGGER Test1
no cascade before insert ON S_Company
REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL
WHEN (clientid NOT IN (SELECT clientid FROM s_client))
SIGNAL SQLSTATE '75000' ('Referencial integrity Error before insert')

My table structure is

Database A, Table S_Client
clientid integer not null,
Description Varchar(30),
Location Varchar(30),
companyid integer not null,
dbname varchar(20)

Database B table S_Company

companyid integer not null,
Description Varchar(30),
Location Varchar(30),
clientid integer not null,
if i delete the Client in db A, it should delete the companies having clientid same in DB B

Sakthi