Archives of the TeradataForum

Message Posted: Thu, 21 Feb 2002 @ 19:36:02 GMT

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

Tony Howe wrote:

RETCANCEL and RETLIMIT are BTEQ control statements. The database will still build the entire answer set for the SELECT statement as a SPOOL file before returning the first row. When RETLIMIT is reached, BTEQ stops retrieving rows (RETCANCEL ON), or continues to retrieve but not display or export rows (RETCANCEL OFF).

Use the "SAMPLE" function in your SQL to limit the number of rows the AMPs place in SPOOL:

LOCKING CPCLMD.QCLMD002 FOR ACCESS
  SELECT AQBICLS, ALLIAAA
   FROM  CPCLMD.QCLMD002
  SAMPLE 100;

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