Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.

     .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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016