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
 

 

Query : LOCATOR

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

New User


Joined: 01 Sep 2008
Posts: 32
Location: chennaii

PostPosted: Mon May 17, 2010 4:23 pm    Post subject: Query : LOCATOR
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon May 17, 2010 5:54 pm    Post subject:
Reply with quote

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
View user's profile Send private message
kothai

New User


Joined: 01 Sep 2008
Posts: 32
Location: chennaii

PostPosted: Tue May 18, 2010 9:17 am    Post subject: Reply to: Query : LOCATOR
Reply with quote

which link Anuj ?
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue May 18, 2010 9:24 am    Post subject: Re: Reply to: Query : LOCATOR
Reply with quote

kothai wrote:
which link Anuj ?

Have you tried to move your cursor here
Back to top
View user's profile Send private message
kothai

New User


Joined: 01 Sep 2008
Posts: 32
Location: chennaii

PostPosted: Tue May 18, 2010 9:37 am    Post subject:
Reply with quote

I am working in DB2 SPs Mainframe.. The link specified in realted to SQL... So i couldnt use it
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue May 18, 2010 2:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue May 18, 2010 5:59 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 18, 2010 6:13 pm    Post subject:
Reply with quote

Quote:
which link Anuj ?
most probably s/he could not recogniged that the words "the link" is a(n) HTML text. In that case, I'd post the URL here: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/sqlp/rbafyresultsete2.htm
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 18, 2010 6:21 pm    Post subject:
Reply with quote

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! icon_smile.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue May 18, 2010 7:14 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 18, 2010 7:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Tue May 18, 2010 7:31 pm    Post subject:
Reply with quote

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
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
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts SQL Query optimization. arunsoods DB2 12 Sun Sep 04, 2016 6:27 am
No new posts Query on BLSR Nileshkul JCL & VSAM 2 Sat Aug 13, 2016 5:18 am


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