|
View previous topic :: View next topic
|
| Author |
Message |
anuradha
Active User
Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad
|
|
|
|
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 |
|
| Back to top |
|
 |
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 237
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.
| Code: |
http://member.netease.com/~jnkey/as400flr/400learn/sql400tutorial/chap15/footnote.htm |
Hope this helps,
Regards
Mayuresh Tendulkar |
|
| Back to top |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 237
Location: USA
|
|
|
|
Hello anuradha,
Here is the more appropriate link for the question.
| Code: |
http://prd4p.it.state.wi.us/etf/wisc/adbhome/db2programmingstandardsandguidelines.doc |
Hope this helps,
Regards
Mayuresh Tendulkar |
|
| Back to top |
|
|
|
|
