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
 

 

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 Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm


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