Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Mar 2001 @ 23:40:42 GMT


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


Subj:   Re: NCR should allow fastexport delimiters
 
From:   Jeff Ohlman

"There's a tool for every job" - I agree with that, but unfortunately there is not a tool for exporting large amounts of data from Teradata with a delimiter.

BTEQ is too slow to use on more than 1 or 2 thousand records.

You can write an outmod for FastExport but this is very time consuming and maintenance heavy.

You can put the delimiters in the SQL of the FastExport, but this is tedious and less than ideal.

The only other option is to pass the data through a filter after the FastExport - which is better than nothing I suppose.

I do not see why providing the option for delimiters in FastExport would affect those users who DO NOT wish to use it. Like all options it is OPTIONAL and therefore could be implemented so that it would not affect those users who do not wish to use it. This solution would be ideal for those users who have a real need to have large amounts of delimited data.



     
  <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