Archives of the TeradataForum

Message Posted: Thu, 21 Feb 2008 @ 22:58:51 GMT

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

Another technique (applicable only to BTEQ) is to tell BTEQ that dropping a non-existent table is okay, like so:

     .set errorlevel 3807 severity 0;
       BTEQ -- Enter your DBC/SQL request or BTEQ command:

     drop table prodm.lskdjflsjf;
       *** Failure 3807 Object 'prodm.lskdjflsjf' does not exist.
                      Statement# 1, Info =0
       *** Total elapsed time was 1 second.

     .quit;
       *** You are now logged off from the DBC.
       *** Exiting BTEQ...
       *** RC (return code) = 0  /******** Note the 0 return code. **********/

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