Archives of the TeradataForum

Message Posted: Fri, 21 Apr 2006 @ 17:08:42 GMT


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

Subj:		Re: Trigger Problem

From:		Michael Larkins

Thanks for the thought Victor. I am a little confused regarding your posting and hope that maybe you can help me understand what you mean by: "BEFORE row triggers cannot have data-changing statements as triggered action SQL statements"

I am asking because a row trigger only allows an INSERT and it contains an INSERT. So, it is the "data-changing" part that has me scratching my head. I am always interested in learning something new that I personally haven't experienced.

Thanks,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor