Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 26 Apr 2007 @ 21:40:10 GMT


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


Subj:   Re: SQL Assistant - Export Results
 
From:   Bob Widman

Barry Hull wrote:

  Use the "Export report" option and set the SEPARATOR to a tab. To do this, you will type a single quote, then hit the tab key, then type another single quote. If you don't want headings and everything, you'll want to turn the FORMAT off, and make the titles on all of the columns a ''. Also, set the TITLEDASHES off.  


I have attempted this option, and while it's close, it still is a fixed width output containing a lot of white space (spaces) between the columns to keep the columns aligned. These spaces are causing the export file size to be incredibly large. Using SQL Assistant as previously described prevents the white space, and only contains a single tab as the column separators.



     
  <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