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: 6967
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: 1281
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: 2433
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: 2433
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
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm


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