Archives of the TeradataForum
Message Posted: Wed, 18 Jul 2007 @ 13:22:57 GMT
| Subj: | | Re: Export Issue Retrieving 400 Columns |
| |
| From: | | Geoffrey Rommel |
| | I have a query with 400 columns. When I tried exporting the data in a flat file and could get only 100 columns in the file. | |
As people often say on this forum, You Need to Provide More Information (tm). Are you using BTEQ? SQL Assistant? FastExport? etc. .....
I will guess that you are using BTEQ. If so, you need to make the output wider by saying
.set width 65000
(or however wide you need). Recent versions of BTEQ allow widths up to 64K or so. Also
.export report file=yourfilename (text format)
will use more space than
.export data file=yourfilename (binary)
| 
