Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Jul 2003 @ 21:27:25 GMT


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


Subj:   Re: Release fload command?
 
From:   uknair

There is no release fload.

No need to drop the table also.

You will have to run an empty fastload to release the table lock.

Put this in sql file, say a.sql

sessions 1;
LOGON PROD/user,pwd;
BEGIN LOADING DBname.TBLname ERRORFILES err_db.et1, err_db.et2;
END LOADING ;
LOGOFF;

and from the command prompt(hope you are on Unix) fastload < a.sql

Hope that helps.



     
  <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: 15 Jun 2023