Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us