Archives of the TeradataForum

Message Posted: Mon, 03 Aug 2009 @ 20:38:57 GMT

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

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

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