Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2007 @ 13:35:11 GMT

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

Subj:   Re: BTEQ Export Limit
From:   Victor Sokovin

  However, this will not limit the rows put into SPOOL. Instead, after all the rows have been selected, it will return only that many rows and then throw the rest away.  

Yes, but what if "the rest" contained the most valuable information?

To the OP: if you are dumping the file on a Unix box, did you try to run the "ulimit -a" command for the same Unix user that executed the Bteq script?

Perhaps there are some restrictions on the "file size" level?

Victor (who is otherwise not encouraging lengthy Bteq exports, especially in the REPORT mode)

  <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