Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 14:02:18 GMT


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

Subj:		Setting Stored Procedure Exit Status ??

From:		Anomy Anom

<-- Anonymously Posted: Wednesday, June 02, 2010 09:53 -->

If we have Stored Procedure and within its logic, we want to exit with a notification (e.g. error level, etc.) to tell the BTEQ script that called it that we encountered a problem and want to logically 'abort' my script/process - what is the best way to do that? At the moment we just code to leave the proc when we identify the error level but need to know that the process should NOT continue. I've searched the SP documentation but have been unable to identify a way. It's probably in there but it's not apparent to me at least;-(

The condition that causes a 'logical abort' in the logic may or may not be a result of an SQL statement. i.e. we may execute a piece of SQL and the result set (although a valid and successful request) has the wrong value for the logic and the proc needs to be terminated and the stopped.

Any assistance/examples would be helpful.

Thank you in advance for your assistance - much appreciated.