|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/20/2009 1:54:19 PM
Posts: 5,
Visits: 53
|
|
HI
I have a table "table1" and a delete trigger created on that table, which populates "table2"
In oracle when we use TRUNCATE command on "table1" we get no rows inserted in "table2", whereas in teradata for each row, delete trigger inserts a row on "table2".
I have tried " DELETE ALL "
" DELETE FROM "
Is there a similar kind of command i can use in Teradata for above setup, so that rows are not inserted on DELETE ALL.
Thanks
~ Truth is stranger than fiction ~
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/18/2009 4:36:17 AM
Posts: 5,
Visits: 11
|
|
|
Are you using row-level trigger or a Teradata Triggered Statement ?
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/20/2009 1:54:19 PM
Posts: 5,
Visits: 53
|
|
Yes, am using Row Level trigger
create deltrig1 after delete on deltest1
REFERENCING OLD AS old_row
for each row (insert into deltest2 values(old_row."key",'row delted');)
~ Truth is stranger than fiction ~
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
You should always try to rewrite a row trigger to a statement trigger, which is much faster.
ALTER TRIGGER foo DISABLED;
DELETE FROM tab;
ALTER TRIGGER foo ENABLED;
Dieter
|
|
|
|