Archives of the TeradataForum
Message Posted: Wed, 01 Dec 2004 @ 16:50:25 GMT
| Subj: | | Re: Do Triggers really need Perm Space???? |
| |
| From: | | Terry Stover |
I suspect perm space is needed to support the REFERENCING clause, you have to put the data associated with OLD/OLD_TABLE and NEW/NEW_TABLE
somewhere.
It makes more sense to put it with the trigger rather than altering the associated table structure. I can see how using temp or spool instead
of perm space could cause integrity problems if you had a failure while a trigger was executing.
| 
