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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


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