Archives of the TeradataForum
Message Posted: Wed, 18 Jul 2007 @ 20:34:49 GMT
| Subj: | | Re: Export Issue Retrieving 400 Columns |
| |
| From: | | Dieter Noeth |
Rameshkumar Jeyaraj wrote:
| | Thanks Romme! I tried running the export statement in Bteq and still not able to retrieve the all the columns. I am able to view only 100
columns. I have another 300 columns missing in my report | |
You don't have to set WIDTH/TITLEDASHES/SEPARATOR in DATA-mode.
The maximum number of columns to return is 100 by default, use RETLIMIT to modify that:
.set retlimit * 2048;
Dieter
| 
