Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 15:15:27 GMT


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


Subj:   Drop tera table
 
From:   Mayur Parikh

I want to drop the table if it exists in mload script.

IF exist(dev.inslogtable)
then drop table dev.inslogtable
endif

Please help me with syntex and where to put it. For some reason successful run of mload script does not drop this table which is my logtable and since this log table is not dropped I can not run the script again.

THANX

Mayur



     
  <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