Archives of the TeradataForum
Message Posted: Wed, 12 Oct 2005 @ 19:31:02 GMT
Subj: | | Re: BTEQ - Macros inside transactions |
|
From: | | Dempsey, Mike |
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
|