Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: BTEQ Question
 
From:   Fred W Pluebell

Tony Howe wrote:

  Isn't the RETCANCEL supposed to cancel the request once the RETLIMIT is reached??  



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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016