IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

COBOL Store Proc: fetching two cursor on two GTT sametime !!


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 12:57 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 1:34 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 2:00 pm
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: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Feb 10, 2010 2:09 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 2:15 pm
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: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Feb 10, 2010 2:22 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 2:25 pm
Reply with quote

Hi Peter!
not a hero, I just love mountain climbing and skying
www.planetmountain.com/expeditions/islanda/index.html
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: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Feb 10, 2010 2:32 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 4:05 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Feb 10, 2010 4:15 pm
Reply with quote

early help ==> urgency
see 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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Excuting store procedure via JCL batch JCL & VSAM 1
No new posts Executing DB2 SQL store procedure via... DB2 0
No new posts COBOL sorting, with input GDG base COBOL Programming 7
No new posts Need help with ADABAS query (COBOL-AD... All Other Mainframe Topics 0
No new posts Starting a PROC with parameters from ... CLIST & REXX 6
Search our Forums:

Back to Top