|
View previous topic :: View next topic
|
| Author |
Message |
kothai
New User
Joined: 01 Sep 2008
Posts: 32
Location: chennaii
|
|
|
|
Hi Team,
I have 3 SPS.
SP1 caling SP2 calling SP3. I have a cursor in SP3 which needs to be passed to the SP1.
I have included Locator synataxs in SP1.
EXEC SQL
ASSOCIATE RESULT SET LOCATORS(:host variable)
WITH PROCEDURE SPNAME
END-EXEC
In the SPNAME, I should use SP3 directly or I need to pass the cursor thru SP2.
Thanks in Advance.
Regards,
Kothai. E |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| It's little tough to answer it right-away and it's been a while when i worked on Stored procedures - however, have you had a chance to go through this link. |
|
| Back to top |
|
|
kothai
New User
Joined: 01 Sep 2008
Posts: 32
Location: chennaii
|
|
|
|
| which link Anuj ? |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| kothai wrote: |
| which link Anuj ? |
Have you tried to move your cursor here |
|
| Back to top |
|
|
kothai
New User
Joined: 01 Sep 2008
Posts: 32
Location: chennaii
|
|
|
|
| I am working in DB2 SPs Mainframe.. The link specified in realted to SQL... So i couldnt use it |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
kothai,
the subject of the link Anuj provided is:
Example 2: Call a stored procedure which returns a result set from a nested procedure
what are you complaining about?????
unless your abbreviation SPs does not mean Stored Procedures. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| dbzTHEdinosauer wrote: |
kothai,
the subject of the link Anuj provided is:
Example 2: Call a stored procedure which returns a result set from a nested procedure
what are you complaining about?????
unless your abbreviation SPs does not mean Stored Procedures. |
the link is for iSeries. It could be (and probably is) the same on z/OS, but no guarantees.
Besides the question is easily answered by just trying it out. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| GuyC wrote: |
| Besides the question is easily answered by just trying it out. |
Changing perception (making others to realize to do something) was never a cake walk for me!  |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Hello Anuj,
i got a retina operation in my left eye a few weeks ago.
And that insect is just the first thing i see in that eye, so
all the time im wondering is it my eye doing tricks? In short
im getting worried/stressed like hell. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| LOL - didn't Doctor tell you that unknowingly you were doing the best exercise for eyes by following the movements of that insect? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Anuj,
im quite serious (i really had that operation). My surgeon told me to fix my eyes on your great prose/poetry on this site. But how can i do that
with that distracting bug. |
|
| Back to top |
|
|
|
|
