Archives of the TeradataForum

Message Posted: Wed, 12 Oct 2005 @ 19:30:03 GMT

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

This is just script execution behavior and is not specific to macros or BT/ET.

SQL Assistant has an option "Stop query execution if an SQL error occurs" set by default; I presume Atanasoft has something similar.

BTEQ default behavior is to continue executing the script. The MAXERROR command can be used to make BTEQ abort on any error:

     .SET MAXERROR 4;

Or you can explicitly test ERRORCODE and/or ERRORLEVEL after each SQL statement.

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