Archives of the TeradataForum

Message Posted: Fri, 15 Feb 2002 @ 21:14:25 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I cannot get my trigger to delete from table FACSECT2T. When I delete from FACSECTT, I need to delete the corresponding row from FACSECT2T. I've tried many different things (such as removing the FACSECT2T qualifier in the where clause). What am I doing wrong? I am on V2R3.

REPLACE TRIGGER FACSECTDELTRG AFTER
DELETE ON FACSECTT
 REFERENCING OLD_TABLE AS OLDROW
FOR EACH STATEMENT
(DELETE FROM FACSECT2T
 WHERE
( FACSECT2T.FAC_TERMA  = OLDROW.FAC_TERMA  AND
  FACSECT2T.FAC_TERMZ  = OLDROW.FAC_TERMZ  AND
  FACSECT2T.FAC_TYP    = OLDROW.FAC_TYP    AND
  FACSECT2T.FAC_DESIG  = OLDROW.FAC_DESIG  AND
  FACSECT2T.FR_ID_NO_A = OLDROW.FR_ID_NO_A AND
  FACSECT2T.FR_ID_NO_Z = OLDROW.FR_ID_NO_Z AND
  FACSECT2T.FAC_USE    = OLDROW.FAC_USE    AND
  FACSECT2T.UCR        = OLDROW.UCR        AND
  FACSECT2T.FAC_ST     = OLDROW.FAC_ST
);
);

Thanks,

Shelly Conley

	<Prev	Next>		<<First	<Prev	Next>	Last>>