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
 

 

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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: 2422
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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: 2422
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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: 2422
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
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: 1278
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
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am


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