Results 1 to 3 of 3

Thread: sp PROBLEM?

  1. #1
    Join Date
    Dec 2006
    Posts
    17

    Unanswered: sp PROBLEM?

    Hi,

    I wrote a Stored Procedure to update a field. But it is not working.
    Would you please help me?


    DECLARE COUNT INTEGER;
    SET COUNT = 1;
    WHILE COUNT < 478 DO
    UPDATE NUMA.ANALIZBILGI T SET T.ID = COUNT WHERE T.ORNEKNOSIRA = COUNT;

    SET COUNT = COUNT + 1;
    END WHILE

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Dec 2006
    Posts
    17
    sorry i have not read it.

    I m using 8.02 on windows XP.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •