Archives of the TeradataForum

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

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

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>>