Problem with cursors

gjain12

When i am trying to loop through cursor using a not found continue handler I am facing a problem, for a select staement inside cursor loop the not found condition is getting true and hence the cursor loop is also getting completed

Expand|Select|Wrap|Line Numbers

    DECLARE CONTINUE HANDLER FOR NOT FOUND 

   SET at_end=1;

   OPEN C1;     

   FETCH C1 INTO perm;

   WHILE at_end = 0 DO

    <some select statement   which returns null some time> 

    <when null is returned the continue handler set at_end=1>.. :(

  FETCH C1 INTO perm

END WHILE;

   CLOSE C1;

Problem with cursors

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about