Archives of the TeradataForum

Message Posted: Wed, 12 Dec 2007 @ 22:27:11 GMT

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

Castelli:

The best way to do this is use TOP n in your SELECT to only put that many rows into SPOOL.

You can use .export report file=filename.txt, limit=n /* n = number of rows */

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.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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