 |
 |
Archives of the TeradataForum
Message Posted: Thu, 13 Dec 2007 @ 13:35:11 GMT
| 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)
| |
