Heya
Newbie taking his first steps in DB2, so bear with me please :
I've created a trigger to perform an INSERT after another row was added to another table. the two tables have foreign keys that both point to a third table, to the same column (it's primary key in fact). I gave all foreign keys the "ON UPDATE NO ACTION ON DELETE NO ACTION" as the IBM references suggests, but still the -530 error pops up on the trigger's run. probably doing something wrong here ... but what ?
tnx !
Newbie taking his first steps in DB2, so bear with me please :
I've created a trigger to perform an INSERT after another row was added to another table. the two tables have foreign keys that both point to a third table, to the same column (it's primary key in fact). I gave all foreign keys the "ON UPDATE NO ACTION ON DELETE NO ACTION" as the IBM references suggests, but still the -530 error pops up on the trigger's run. probably doing something wrong here ... but what ?
tnx !