Hi All,

I have following cursor in Oracle stored procedure using %rowtype attribute:

CURSOR cur_users is
select * from users where sysdate > VALIDTILLDATE ;
cur_users_rec cur_users%rowtype ;
BEGIN
For cur_users_rec in cur_users
LOOP
If cur_users_rec.VALIDTILLDATE is null then
null ;

Else

Update users set IsDeleted ='T' where userid = cur_users_rec.userid ;

End if ;

COMMIT;
END LOOP ;

I am unable to find a substitute for %rowtype in Db2. From IBM help on site, I could find only an Anchored record decalaration can be converted by declaring structures with matching layout. But could not understand exactly. Can you please help out.

Thanks a lot .