Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Conditional Table Drop
From:   Geoffrey Rommel

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.

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020