|
View previous topic :: View next topic
|
| Author |
Message |
rohanthengal
Active User
.jpg)
Joined: 19 Mar 2009
Posts: 206
Location: Globe, India
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10891
Location: italy
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3077
Location: NYC,USA
|
|
|
|
| Can you explain more what you are doing? People may offer you different solutions to achieve it. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2157
Location: USA
|
|
|
|
| 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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3077
Location: NYC,USA
|
|
|
|
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 |
|
|
|
|
