Archives of the TeradataForum

Message Posted: Wed, 18 Jan 2006 @ 15:25:52 GMT

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

Hi Dave:

I am not entirely sure I understand all of your requirements, but it sounds like you want to not do the delete if the row does not have a 'P' stored in it already and you want this to be checked by the trigger.

If this interpretation is correct, then you need to use the WHEN portion of a trigger to check the row for the 'P'. This is a well documented capability in the user manual. It is the only place in a trigger where you can do a SELECT.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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