Archives of the TeradataForum
Message Posted: Mon, 03 Aug 2009 @ 20:38:57 GMT
Subj: | | Error Handling in BTEQ Export |
|
From: | | Varun Kore |
Hi,
I export variables into files using bteq export. I would like to know how to include error handling into this i.e. when the "rm" command tries
to remove the file but is unable to do so due to improper permissions, I want the Bteq to come out and throw an error which I can catch in
unix.
I tried using 'ERRORCODE' but it did not work. Any ideas will be helpfull.
bteq< 0 THEN .QUIT 25;
.EXPORT REPORT FILE=./XLIST/curr_exec_id.dat;
.IF ERRORCODE <> 0 THEN .QUIT 25;
SELECT current_date;
.IF ERRORCODE <> 0 THEN .QUIT 25;
.EXPORT RESET;
.IF ERRORCODE <> 0 THEN .QUIT 25;
.quit
.exit
!
Thanks and Regards
Varun Kore,
Associate System Engineer
|