Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Mar 2002 @ 16:27:09 GMT


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


Subj:   Stored Procedure Question about Cursors
 
From:   Jeremy Christiasnen

I have a complicated update that I want to do on a table. It's far too complicated for SQL alone to handle but I believe a stored procedure would do the trick. I would like to write a procedure that takes each row from this table, puts it through a battery of logic, and then updates that row in the table. This is doable. However, my problem is that in order to do this, it seems that I am forced to use a cursor. This is too slow. I do not want the updates to happen one at a time. I'd like to combine the flexibility of procedure variables and manipulation with the speed of doing a "normal" update on a table. Is this possible with stored procedures? (Note: I'm asking if this is possible with stored procedures. I am fully aware that there are other methods to accomplish what I want.)



     
  <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