Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 14:23:34 GMT

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

You can still code in SQL the logic you want to be executed and based on the result you can take some action. You can also cause an intentional error if you think it should stop say 1/0 will raise an error. Similar logics can be added to raise different error level and you can store them onto a table and at the same time you can proceed/continue or abort. Also remember outside SP in execution level you can take all kind of actions. Say you are invoking this using Bteq and thus your controlling steps are much robust. You can use .GOTO or .IF then etc.

Hope this helps.

Thanks

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