|
|
Archives of the TeradataForum
Message Posted: Thu, 26 Apr 2007 @ 21:40:10 GMT
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.
| |