|
View previous topic :: View next topic
|
| Author |
Message |
rakhisoman
New User
Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India
|
|
|
|
| Can we delete a cursor? Is it a temporary storage which gets deleted automatically after our program execution? |
|
| Back to top |
|
 |
prasadvrk
Active User
Joined: 31 May 2006
Posts: 200
Location: Netherlands
|
|
|
|
| I think CLOSE CURSOR will take care of the releasing the memory , if you do not expilcitly code CLOSE CURSOR then after the execution of the program CURSOR will be automatically closed there by releasing the memory. |
|
| Back to top |
|
|
rakhisoman
New User
Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India
|
|
|
|
| Thank you for the reply.But is it possible to delete the cursor explicitly in our program. |
|
| Back to top |
|
|
parikshit123
Active User
.jpg)
Joined: 01 Jul 2005
Posts: 269
Location: India
|
|
|
|
Hi Rakhi,
Cursor is a program construct rather than an object in the DB2. So, when we say "delete a cursor" , that doesn't mean anything.
Yes, if you want to ask "Can we delete rows fetched by a cursor?". Yes we can. |
|
| Back to top |
|
|
rakhisoman
New User
Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India
|
|
|
|
| Thank you that clears my query |
|
| Back to top |
|
|
|
|
