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
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.