IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

want to open and fetch the cursor in program B.


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Calling an Open C library function in... CICS 1
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to pass the PARM value to my targ... COBOL Programming 8
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
Search our Forums:

Back to Top