Archives of the TeradataForum
Message Posted: Wed, 12 Oct 2005 @ 19:30:03 GMT
Subj: | | Re: BTEQ - Macros inside transactions |
|
From: | | Fred W Pluebell |
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.
|