Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Sep 2003 @ 17:34:00 GMT


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


Subj:   Re: Stored Procedure that Loops
 
From:   David Stanek

Try the following:

  Declare ACT_CT INTEGER;
  SET ACT_CT = 1;

    WHILE ACT_CT NE 0
    DO

      s1. a SQL bulk delete
      s2. a bulk ins/sel
      s3. a bulk Update

    SET ACT_CT = ACTIVITY_COUNT;
    END WHILE;

Respectfully,

David M. Stanek

DMS Consulting Services, Inc.



     
  <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