Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Can we pass cobol pointer to cobol-db2 stored proc

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 190
Location: Globe, India

PostPosted: Tue Mar 19, 2019 1:04 pm    Post subject: Can we pass cobol pointer to cobol-db2 stored proc
Reply with quote

Hi,
I need to pass a cobol pointer to a cobol db2 stored procedure. Is there any way by which I can declare a pointer as input to a stored procedure? I could not find relevant data type for pointer in SQL. Pls advise if anyone has any idea,
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10662
Location: italy

PostPosted: Tue Mar 19, 2019 2:42 pm    Post subject: Reply to: Can we pass cobol pointer to cobol-db2 stored proc
Reply with quote

just review Your understanding of stored procedures runtime environment
and You will understand why what You ask is impossible

hints
1) at least the stored procedure will run in a different address space
2) the stored procedure might even run in a different processor ( specialty engine )
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2343
Location: NY,USA

PostPosted: Wed Mar 20, 2019 1:12 am    Post subject:
Reply with quote

Can you explain more what you are doing? People may offer you different solutions to achieve it.
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 712
Location: Maryland

PostPosted: Wed Mar 20, 2019 6:38 pm    Post subject:
Reply with quote

Rohit Umarjikar wrote:
Can you explain more what you are doing? People may offer you different solutions to achieve it.

Obviously, the person wanted to somehow manipulate with variables of his application from inside the stored procedure, with no basic understanding of what enrico-sorichetti has clarified in short terms.

The original topic, when simplified, is equivalent to "I need to apply explosives to my brick wall in the first floor of our hundred-story building, in order to fix the nail, and to hang a small picture on the wall".
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2343
Location: NY,USA

PostPosted: Sat Mar 23, 2019 5:15 am    Post subject:
Reply with quote

That’s right but no harm getting know what is the actual requirement here than knowing it can’t work with pointers.

Let us see if TS is still interested to reply on this or just to let it go and don’t do nothing.
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 COBOL batch program using large size ... Akriti Mishra COBOL Programming 3 Thu Mar 26, 2020 11:37 pm
No new posts Trying to submit COBOL PGM - JCL ERRO... sandeep prajapati JCL & VSAM 5 Tue Mar 24, 2020 11:21 pm
No new posts How to create UUID using COBOL PORYES COBOL Programming 0 Tue Mar 17, 2020 4:43 pm
No new posts Execute DSNTEP2 in REXX which is call... sushanth bobby CLIST & REXX 4 Wed Mar 04, 2020 3:27 pm
This topic is locked: you cannot edit posts or make replies. Cobol db2 program going in loop sivasaras COBOL Programming 4 Sat Feb 29, 2020 7:44 pm

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