Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Dec 2005 @ 20:49:43 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: FastExport and the number of sessions vs. skewing
From:   Victor Sokovin

  As you noted, OUTLIMIT is applied on the client side as data is being returned. You'll need either need a higher spool space limit or a SQL change (e.g. added WHERE criteria) to limit the size of the result set.  

The FastExport manual contains an example of how to do it. It can be found in "Using Checkpoints in a Single Export Job".

Checkpoints can also save time when the job needs to be restarted after a failure.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023