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
 
want to open and fetch the cursor in program B.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
suzeet

New User


Joined: 16 May 2005
Posts: 54

PostPosted: Tue Jan 10, 2006 2:55 pm    Post subject: want to open and fetch the cursor in program B.
Reply with quote

I have a program A and calling another program B. Now in the program A the cursor is C1. The cursor is declared in program A.
Now I want to open and fetch the cursor in program B. Is it possible? If not why? If yes why and how?
Back to top
View user's profile Send private message

suzeet

New User


Joined: 16 May 2005
Posts: 54

PostPosted: Tue Jan 10, 2006 2:58 pm    Post subject:
Reply with quote

I have a calling program and a called program. Both are bound to same plan but different collection. Now in the program how do you call the called program.
Back to top
View user's profile Send private message
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Tue Jan 10, 2006 5:25 pm    Post subject:
Reply with quote

#2) using plan/packege doesn't make any difference in application program. It will be a normal call only. That's my understanding.Please correct me if i'm wrong
Back to top
View user's profile Send private message
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Tue Jan 10, 2006 5:45 pm    Post subject:
Reply with quote

#1) Yess you can do that. You can declare in one program and open in another program if you delare cursor as a global cusor. icon_wink.gif u need syntax??

DECLARE <Cursor_Name> CURSOR
[LOCAL | GLOBAL]
[READ_ONLY | SCROLL_LOCKS | OPTIMISTIC]
FOR <Selecting Statements>
[FOR UPDATE [OF Column_name[,....N]]]
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

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