Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Delete TRIGGER help
 
From:   Mary M. Conley

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016