Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Apr 2007 @ 20:27:33 GMT

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

Subj:   Re: SQL Assistant - Export Results
From:   Rob Paller

Try casting your fields to VARCHAR in a derived table then:

     SELECT  || '|' ||  || '|'|| ... 
        FROM derived table;

Keep in mind the report width limitations in BTEQ. You may need to use FastExport and then strip the leading two bytes of binary data from the resulting file in either an OUTMOD or external process. I know UNIX provides a few built in mechanisms to facilitate such processing.

Good Luck.

  <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