CURSOR DEFN

anuradha · Global Moderator Joined: 06 Jan 2004 Posts: 257

A cursor can be declared (defining a cursor) in working storage or procedure division i hope.i want to know the difference.

can anyone explain me the difference of declaring a cursor in procedure division and declaring it in working storage.

THANKS AND REGARDS
ANU

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

Hello anuradha,

The usage of the DECLARE CURSOR statement is the flexibility which IBM has provided.

You can use it anywhere in your program since it is not an executable statement. I think its just the question of standards which your site follows.

Look at the link below to get more details.

http://member.netease.com/~jnkey/as400flr/400learn/sql400tutorial/chap15/footnote.htm

Hope this helps,

Regards

Mayuresh Tendulkar

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

Hello anuradha,

Here is the more appropriate link for the question.

http://prd4p.it.state.wi.us/etf/wisc/adbhome/db2programmingstandardsandguidelines.doc

Hope this helps,

Regards

Mayuresh Tendulkar