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 = ...
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?).