Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Sep 1999 @ 14:47:17 GMT


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


Subj:   Re: Archive Processing
 
From:   Fred Pluebell

The utility processes statements in sequence. If you are using multiple COPY statements (one per table), then the input DD will be closed when the first statement completes. If the second COPY statement happens to reference the same DDNAME, it will be re-opened for input. This requires repositioning to the start of the dataset; I think NOREWIND would only defer this from the CLOSE to the subsequent OPEN. If you are restoring a list of tables in the same COPY statement, then one sequential pass should be sufficient.

Yes, the Archive utility requires a TDP to be available, even if you are only doing something like ANALYZE. The same is currently true of the SQL Pre-Processor PP2.



     
  <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