 |
 |
Archives of the TeradataForum
Message Posted: Sat, 07 Aug 2004 @ 11:30:36 GMT
| Subj: | | Re: What's the BTEQ Syntax to Export Fixed-Field Text from Teradata Table for Cognos Transformer |
| |
| From: | | Dieter Noeth |
Joseph Massena wrote:
| | This is what I am using for csv but what's the syntax for fixed width with Column Titles? Any help greatly appreciated! | |
.set titledashes off;
.set width 254
.set separator '';
.export report file = ...
select ....
.export reset
The maximum width is 254, so you hopefully don't need more than that... Only the newest release of BTEQ (8.2.1) knows REPORTWIDE up to
32K (or 64K?).
Dieter
| |
