Archives of the TeradataForum
Message Posted: Mon, 03 Aug 2009 @ 20:38:57 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|