Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
COBOL Store Proc: fetching two cursor on two GTT sametime !!

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

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 12:50 pm    Post subject: COBOL Store Proc: fetching two cursor on two GTT sametime !!
Reply with quote

Hi,

In my project JAVA is calling a store proc written in host lang COBOL.
Now If I declare two Global Temp table and open two cursor on them,how java will get those result set?
I have declared the stored proc with option result set 2.
Now I am trying to open two curosr defined on two GTT same time...my concerns is java will get those same time,or one after one ?

Please clarify.
Early reply would be helpful.
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 12:57 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

Quote:
Early reply would be helpful.


people reply on their own time!
what makes You think that Your time is more valuable than ours?

please do not double post! the post in the cobol forum will be deleted
Back to top
View user's profile Send private message
mad_guy
Currently Banned

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 1:20 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

Hey enrico-sorichetti

I just made a request!!!! whats wrong in that ?
why u r behaving like that....?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 1:34 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

Quote:
Early reply would be helpful.
You can make that kind of requests when You pay, not when You get something at no charge!

And there is unanimity everywhere on the net that claiming urgency , is bad manners

Quote:
why u r behaving like that....?
I am not behaving in any way I am just telling You about proper netiquette !
by the way, have Your keyboard fixed,please, it drops letters and makes Your messages hard to understand icon_biggrin.gif

and I am not Your dog or Your girlfriend that You can address with hey
Back to top
View user's profile Send private message
mad_guy
Currently Banned

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 1:45 pm    Post subject:
Reply with quote

U r no one ...to tech me manners....
And .. I can make a humble request everywhere...whether I pay or not...
Its a simple thing..only U r making it a big issue ...My be u r going through a rough time...its ok...
And why u r worrying a lot...let ppl reply at their convenient time... I m not forcing any one to reply early...
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 2:00 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

I am just back from a sky raid and a very nice ice fall climb
why should I worry or be mad or having rough time, apart a bit of cold feet by standing in the snow for eight hours icon_biggrin.gif

by the way Your keyboard is getting worse and worse , the sooner You get it fixed the sooner You will be able to write in an understandable way
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Feb 10, 2010 2:09 pm    Post subject: Re: Reply to: COBOL Store Proc: fetching two cursor on two G
Reply with quote

enrico-sorichetti wrote:
I am just back from a sky raid and a very nice ice fall climb
why should I worry or be mad or having rough time, apart a bit of cold feet by standing in the snow for eight hours icon_biggrin.gif



Hello Enrico,

I hope your feet are not black. icon_eek.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 2:15 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

Hi Peter!
my feet are in a really good shape, the temperature was not that low just 4 degrees below
I have experienced much lower temperatures... 15 below inside the tent icon_biggrin.gif
one evening while cooking inside the tent I dropped the pan with the soup
I just waited ten minutes for it ( the soup ) to freeze on the tent floor and I just put it back!
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Feb 10, 2010 2:22 pm    Post subject:
Reply with quote

Enrico,

you are a hero. How did the tent floor taste? icon_lol.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 2:25 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

Hi Peter!
not a hero, I just love mountain climbing and skying
http://www.planetmountain.com/expeditions/islanda/index.html
http://www.planetmountain.com/expeditions/islanda/02.html
in italian , in the second link my tent is the green one on the right and I am standing by it
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Feb 10, 2010 2:32 pm    Post subject:
Reply with quote

Hello Enrico,

looks great. When i see something like that i always think i want to do
that too.

But this morning i was removing 2 cm snow of my car and the side walk
and cursed my poor life. icon_cry.gif
Back to top
View user's profile Send private message
mad_guy
Currently Banned

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 3:52 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

My keyboard is absolutely fine, it’s just my way of writing, may be its not understandable to you (but still you replying icon_confused.gif )...
I don’t have interest of your worry and all, but you are spoiling the whole thing...
If you don’t have any knowledge about store proc or GTT, why you are still posting scrap here?
Now please stop all these nonsense...
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 4:05 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

if You hadn' t kept up with the early help thing You would have already got a useful reply!
but You wanted to play it smart didn' t You!
Back to top
View user's profile Send private message
mad_guy
Currently Banned

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 4:12 pm    Post subject:
Reply with quote

I still did not get what was your problem with the 'early help' ?
It was just a one liner request.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10607
Location: italy

PostPosted: Wed Feb 10, 2010 4:15 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

early help ==> urgency
see http://catb.org/~esr/faqs/smart-questions.html
Back to top
View user's profile Send private message
mad_guy
Currently Banned

New User


Joined: 15 Jan 2010
Posts: 31
Location: India/UK

PostPosted: Wed Feb 10, 2010 5:15 pm    Post subject: Reply to: COBOL Store Proc: fetching two cursor on two GTT s
Reply with quote

You are too much bookish, analytical

What I deed was just an instinct...
Just a one liner, nothing smart about that or nothing dull about that...
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Feb 11, 2010 8:48 pm    Post subject:
Reply with quote

cstmt1.getMoreResultSets(Statement.KEEP_CURRENT_RESULT);
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 Send text at cursor position on an IS... Domenic Ailati CLIST & REXX 10 Sun Jun 02, 2019 7:34 am
No new posts Cursor result set being updated??? John Poulakos DB2 5 Tue May 28, 2019 10:46 pm
No new posts Regarding mroe data to be processed i... vinu78 DB2 1 Mon May 27, 2019 7:31 pm
No new posts S0C7 abend while running a Cobol Program amitc23 COBOL Programming 2 Tue May 07, 2019 4:06 pm
No new posts POSITIONING THE CURSOR USING REXX MJ SHARATH CLIST & REXX 6 Tue Apr 09, 2019 10:27 am

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