Archives of the TeradataForum

Message Posted: Tue, 18 Jul 2006 @ 19:18:03 GMT

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

Here is one way.....As you know there is the ERRORCODE value that can be interpreted to check the exit status of each line in a BTEQ script. If you code:

     .QUIT ERRORCODE

In the BTEQ script, it will terminate the BTEQ session with what ever ERRORCODE value has been set at that point. Depending on your scripting environment, you then simply need to trap the return condition from the execution of BTEQ.....

Cornelius Meade III
EDS - Consulting Services/BI/CRM

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