Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 13:28:50 GMT


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


Subj:   Re: Nested Cursor
 
From:   Geoffrey Rommel

  Is it Ok to declare the Inner cursor again and again? or is there any other method do it properly.  



As the manual explains, "declare cursor" is a declarative, not an executable, so it is only processed once by the precompiler; it is not executed at run time (SQL Ref., Vol. 6). The open, fetch, and close, however, will have to be executed every time.

Is it possible to rewrite these two selects as a join? Then you would only need one cursor.



     
  <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: 15 Jun 2023