Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 10 Dec 2003 @ 16:16:27 GMT


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


Subj:   Fast Export and file closure
 
From:   Arunachalam, Sankar

Greetings

Below is a piece of export script that I use in one of my daily jobs. The delete file operation fails all the time.

My question is when is a file opened by an export process actually closed and released? Is it not right after the 'End Export'?


Thanks

Sankar


-----------------------------------------------------------
.Logon xxxx
.begin export
  .export outfile a1
   seleect xxxx  -- single row export
    ;
.end export
.Accept export-1-value from file a1 ;
.system 'delete a1 ';   <== always fails with an error message no matter where I plug this command in

                        <== Error message "The process cannot access the file because it is being used by another process."

.begin export
 .export outfile bigfile_&export-1-value ;
   select yyyyy ;
.end export


     
  <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