Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Jul 2007 @ 13:22:57 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023