Archives of the TeradataForum

Message Posted: Wed, 02 Jun 2010 @ 15:29:27 GMT

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

<-- Anonymously Posted: Wednesday, June 02, 2010 10:59 -->

Thank you for the reply, but I don't quite understand the statement, " You can also cause an intentional error if you think it should stop say 1/0 will raise an error."

How can we cause and 'intentional' error and if we do, what do we check for in the BTEQ script that called the Proc when it returns?

e.g. in a BTEQ script we code the folowing:

     CALL mydb.purge_data ( "MEG"  /* OUT: VARCHAR(1000), nullable */ );

When we return to the script, what would we code to detect that the proc 'logically/physically' aborted so we could terminate it with a .QUIT 8 - for example"

Sorry if I'm not making this clearer - apologies.

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