Archives of the TeradataForum

Message Posted: Wed, 12 Oct 2005 @ 19:31:02 GMT

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

BTEQ works the way SQL Assistant would work if you clear the option to "Stop query execution if an SQL error occurs".

In order to make bteq work the way you want you will need to add

     IF ERRORCODE <> 0 THEN .QUIT 8

after the call to the macro. (The '8' can be any return code you like - or it can be 'ERRORCODE' if you want the calling app to know what error occured.)

Mike Dempsey
Teradata Client Tools

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