Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can we delete a cursor?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rakhisoman

New User


Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India

PostPosted: Fri Apr 20, 2007 12:28 pm    Post subject: Can we delete a cursor?
Reply with quote

Can we delete a cursor? Is it a temporary storage which gets deleted automatically after our program execution?
Back to top
View user's profile Send private message

prasadvrk

Active User


Joined: 31 May 2006
Posts: 200
Location: Netherlands

PostPosted: Fri Apr 20, 2007 1:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
rakhisoman

New User


Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India

PostPosted: Fri Apr 20, 2007 1:40 pm    Post subject: Re: Cursor
Reply with quote

Thank you for the reply.But is it possible to delete the cursor explicitly in our program.
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Fri Apr 20, 2007 2:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
rakhisoman

New User


Joined: 16 Mar 2007
Posts: 8
Location: Trivandrum,Kerala,India

PostPosted: Fri Apr 20, 2007 2:32 pm    Post subject: Re: Cursor
Reply with quote

Thank you that clears my query
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts Delete record or Reset RC code using ... mpawan Compuware & Other Tools 4 Tue Jul 26, 2016 3:52 pm
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us