Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 13:04:55 GMT


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


Subj:   Re: Windows-based Fast Export Script
 
From:   Rob Paller

You will likely need to wrap your extract query with a SEL statement that concatenates everything together using the delimiter of your choice and CAST it to the maximum length you expect from each column.

If your export is variable width, FastExport will append a 2 byte character string to the beginning of each row to indicated it's length. This is used by the other Teradata utilities and useless as far as SQL Server will be concened. You can either have SQL Server ignore the first two characters (probably the easiest) or you can write an OUTMOD in C that will strip the leading two characters.

The TeradataForum website should have a link to a UNIX version that is easily modified to work with Windows. I have used the UNIX code myself to do just what I explained above.


--
Rob Paller
Teradata Certified Master



     
  <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