db2 cursor name

lineesh_kumar · New User Joined: 20 Feb 2006 Posts: 6

Hi,

I have 4 cursor which will be executing depending on the condition.

Now I have like

evaluate true
when 1 open cursor1
when 2 open cursor2
when 3 open cursor3
when 4 open cursor4
end

Instead can I use like open ws-cursor, set the ws-cursor in working storage with 4 88 levels of cursor1, cursor2 etc . I will set the 88 level before the opening of the cursor. I know this is some kind of dynamic processing. But is there a way for doing this?

Responses are appreciated.

Regards
Lineesh

dbzTHEdinosauer · Posted: Thu Jul 01, 2010 9:48 pm

the syntax of the declare cursor, open cursor, close cursor and fetch cursor do not allow for the cursor name to be contained in/ or the value of a w-s variable.

if you have 4 cursors, you will need four declare/open/fetch/close cursor db2 api calls.