Declaration cursor in WS section or Procedure Division

mouli · New User Joined: 19 May 2005 Posts: 12 Location: kolkata

Hi All,
What is the difference between declaring the cursor in working storage section and declaring in procedure divison.
Plz explain me.

Regards
Mouli

ayyappa_22523 · New User Joined: 02 Jun 2005 Posts: 36 Location: Hyderabad

HI MOULI

declare the cursor in working-storage and procedure division is same

but most of doing in working srotage section .

urs

AyyAppA

paramreddy · New User Joined: 06 Jun 2005 Posts: 1

HI ,
U can declare the cursor position either working storage or procedure.But usually we use working storage because it is non executable statements(just is declaration of data items) .

mouli · New User Joined: 19 May 2005 Posts: 12 Location: kolkata

Pushpak · New User Joined: 06 May 2005 Posts: 18

Hi

Its depends on you where you have to define a cursor. Only thing you have to take care is definition of cursor should be prior to the OPEN statement of the same cursor.

As definition of cursor is non executable statement, it is advisable not to define in procedure division as it may misunderstood others.

Pushpak.

shailendra · New User Joined: 08 Jun 2005 Posts: 10 Location: Pune

Hi

No need to worry where to declare cursor. You can define it in procedure or working division. It does not cause any difference.

Declare cursur wherever you wish.

shailendra

bnsahoo · Posted: Thu Jun 09, 2005 5:16 pm

It is right,that there is no difference between these two .when open statement is executed then the cursor (Result Table) will be created(declared in the DECLARED statement),so it is like object is instance of class in OOconcept. That is class is blue print of object.
Thanks
Biranchi

Pushpak · New User Joined: 06 May 2005 Posts: 18

Hi All,

I am sorry for my previous statement related to this query. The statement was
"Only thing you have to take care is definition of cursor should be prior to the OPEN statement of the same cursor. "

I have tested it with DB2 Ver 7 & found that you can define CURSOR any where in the application program no matter whether it has been defined. It can be after/before OPEN/FETCH/CLOSE statements of the same cursor.

Sorry once again for your inconvenience.

Pushpak.

ovreddy · Posted: Wed Jun 15, 2005 2:58 pm

Hi Mouli,

I was answered this already ... Please refer to the following post...

www.ibmmainframes.com/viewtopic.php?p=4860&highlight=#4860

Thanks,
Reddy.