Can we Declare a Curosr in Procedure Division?

sanjay_mf · New User Joined: 30 May 2008 Posts: 10 Location: Bangalore

Can we Declare a Curosr in Procedure Division?

Will it give an error if we do so?

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

Yes . We Can Declare

Craq Giegerich · Posted: Wed Jun 25, 2008 4:16 pm

I believe the has been discussed before, did you try searching?

sanjay_mf · New User Joined: 30 May 2008 Posts: 10 Location: Bangalore

I didn't find any.

Can anyone please send me the link of that discussion. Else please answer my query.

Craq Giegerich · Posted: Wed Jun 25, 2008 4:32 pm

It was hard to find I had to go to the second page of the search results.

ibmmainframes.com/viewtopic.php?t=31536&highlight=cursor

dbzTHEdinosauer · Posted: Wed Jun 25, 2008 4:34 pm

sanjay_mf,

I see that you are also a graduate of 'HOW TO MAKE FRIENDS AND INFLUENCE PEOPLE'.

dsnsqh11 is the db2 vsn 7 sql reference
dsnaph11 is the db2 vsn 7 application programmers guide.

If you don't know the answer to these questions you lack a tremendous amount of knowledge which can be best acquired by RTFM.

sanjay_mf · New User Joined: 30 May 2008 Posts: 10 Location: Bangalore

Thanks Craq.....

debajyoti2040 · New User Joined: 25 May 2007 Posts: 4 Location: Bangalore

Definitely you can.
It can be done in Both Working-storage and Procedure Division.