Re: a trigger question

Posted in 2003

Topics: Triggers, Constraints & Referential Integrity

Serge Rielau — Mon, 12 May 2003 09:06:45 -0400 — source: Usenet: comp.databases.informix

A before trigger whould work just fine. If you only need the check upon insert of the record you'll be fine. If you need to maintain this relationship (like in a check constraint) after teh initial insert you will need before triggers on the underlying tables (lets call them parents for lack of a better word) of the query as well. Cheers Serge -- Serge Rielau DB2 UDB SQL Compiler Development IBM Software Lab, Toronto Visit DB2 Developer Domain at http://www7b.software.ibm.com/dmdd/

↪ replying to Serge Rielau

james van hees — Mon, 12 May 2003 16:15:45 GMT — source: Usenet: comp.databases.informix

Hi, > A before trigger whould work just fine. i can't use REFERENCING with a before trigger so i can't reach the tuple wich should be inserted. And i need this tuple because before it's inserted it needs to match a certain property (=tuple must not be in some other table ) , if not: the insert should be rejected. thx for your help, james

↪ replying to james van hees

Serge Rielau — Mon, 12 May 2003 14:25:39 -0400 — source: Usenet: comp.databases.informix

Uhm...that's where I have to bail. I don't know IDS Trigger DDL in that detail. Cheers Serge -- Serge Rielau DB2 UDB SQL Compiler Development IBM Software Lab, Toronto Visit DB2 Developer Domain at http://www7b.software.ibm.com/dmdd/