cursor declaration

prasadrachuri · New User Joined: 19 Aug 2003 Posts: 20 Location: kolkata

Hi,
I have a small doubt regarding declaration of cursor.

1. Can one declare cursor in procedure division

2. If one can declare a cursor in procedure division then does it differ from one which is declared in working storage

...if differs how

Thanks in advance..
Prasad Rachuri...

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 257 Location: USA

Hello prasad,

1) YES....

2) NO, ideally it should not differ.
But not sure on this.

Hope this helps you...

Regards

Mayuresh

prasadrachuri · New User Joined: 19 Aug 2003 Posts: 20 Location: kolkata

Hi Mayuresh,
Nice to see you in the picture once again...

if both doesn't differ in action then why IBM given possiblity of declaring cursor in both the places...

Thanks in advance..
Prasad Rachuri...

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 257 Location: USA

Hello,

Check these links for more informatio on this issue.

http://h71000.www7.hp.com/doc/721FINAL/6607/6607pro_022.html

http://dbforums.com/arch/91/2002/7/435397

The cursor declaration is same as that of what we declare in the Working storage section.

There may be some reasons why IBM has provided this. Need to do some R&D for this.

Hope this helps you.

Regards

Mayuresh