Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 01 Apr 2008 @ 20:22:49 GMT


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


Subj:   Re: Looping SQL Script in Queryman
 
From:   Dempsey, Mike

If you want to use any kind of loop you would need to create a stored procedure (in which you can create a cursor if you need to)

SQL Assistant does not allow any kind of looping unless you are using Import.

In that case it repeatedly executes the query until all the rows have been read from the Import file. (You have no control over the loop.)


Mike Dempsey
Teradata Client Tools



     
  <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