Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 19:15:36 GMT


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


Subj:   Multiload using VARTEXT from Mainframe
 
From:   Rob

I've been having some trouble with a Multiload using multiple record types of VARTEXT from a Mainframe session.

Some observations:-

If there is just one record type then the file can be fixed block.

If you have multiple record types the file must be variable block. A fixed block file can be used but the NOSTOP parameter is required to stop the Multiload failing, and the delimiter is required at the end of the record.


Why you would want a fixed block file for a delimited file I'm not sure but some of the existing process we have use this?

Can anyone confirm these observations or had any experience of multi-record vartext multi-loads they can pass on to me?


Thanks

Rob C



     
  <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