Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 18:21:29 GMT

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

Subj:   Re: MultiLoad With VARTEXT/Delimited Input File
From:   Glen Blood

I don't believe that it exists.

However, if the data is all ASCII, you could load the data into a single column table and then parse it in SQL or use sonething on your load machine to convert it into fixed width.

MLOAD (and FASTLOAD and FASTEXPORT) are based on the mainframe philosophy of predefined fixed width fields, not UNIX/Windows variable length fields.


  <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: 28 Jun 2020