MVSFORUMS.com

sateesh_gontla · Posted: Wed Aug 08, 2007 12:39 pm Post subject: Cursor in cobol

I have the following requirement :

DB2 Table : Region_tab

Fields :
--------
Region
Member
Sel_opt
Score

If the input is given as From Region as :10 & To Region as :20

In the cobol program we need to do this using CURSORS:

Select all the members of Region 10 where Sel_opt = 'Y' and update the same member in Region 20 with score if that member exists in Region 20.

The 2nd requirement :

Fields in Table :

Region
Div
Member
Score
Limit

If any members score = Limit then make the score = 0 by Div wise and By Region wise. basically we need to read under a Region all the Division and under each Division all the members.

kolusu · Posted: Wed Aug 08, 2007 1:14 pm Post subject:

sateesh_gontla,

what exactly do u want us to do here?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

sateesh_gontla · Posted: Wed Aug 08, 2007 1:24 pm Post subject:

will you able to help getting the sql's ?

sateesh_gontla · Posted: Wed Aug 08, 2007 5:53 pm Post subject:

Any HELP !!!!

kolusu · Posted: Thu Aug 09, 2007 8:00 am Post subject:

sateesh_gontla,

Do NOT demand a solution. angry

We are just helping in our part time. Just because you posted a question that does NOT mean that we drop everything and spoon feed you. We have a job of our own.

1.Solution for rqmt # 1

Cursor definition

sateesh_gontla · Posted: Thu Aug 09, 2007 9:02 am Post subject:

Mr.Kolusu,

I never demand any thing, I said "will you able to help" , hope you understand (my) english... if you are willing or don't have time no one here asked/demand anything .....

It's only Request.... Also the solution that you gave me was not correct, please look at my requirements, it is a self join....However thank for your kind help !!!!!

kolusu · Posted: Thu Aug 09, 2007 9:15 am Post subject:

Terry_Heinze · Posted: Thu Aug 09, 2007 9:31 am Post subject:

"Also the solution that you gave me was not correct, please look at my requirements,..."
What have you tried so far?
_________________
....Terry

kolusu · Posted: Thu Aug 09, 2007 9:10 pm Post subject:

sateesh_gontla,

I just happened to look at your previous posts and it seems you always have an attitude. angry

you never post feed back or provide detailed information on requirements for the people who are trying to help you.

ex: this topic

http://www.mvsforums.com/helpboards/viewtopic.php?t=8254

Here are all the topics you started and see how many of them you provided a feed back or got back to provide details

http://www.mvsforums.com/helpboards/search.php?search_id=usertopics&user=1197

Honestly you don't even deserve an answer on this board.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

aquarian · Posted: Mon Aug 13, 2007 4:51 am Post subject:

Seems some serious issue here Smile

_________________
cheers,
Aquarian

sateesh_gontla · Posted: Tue Aug 21, 2007 9:14 am Post subject:

Hi Kolusu,

Please remove all my posts here and Thanks for all your support. I will not disturb you any more !!!

PLEASE REMOVE MY POSTS. Thanks for your help.\

kolusu · Posted: Tue Aug 21, 2007 9:45 am Post subject:

dbzTHEdinosauer · Posted: Tue Aug 21, 2007 10:09 am Post subject:

Many years ago, I received a card which said: 'you are not completely useless, you do serve as a good 'Bad example'. I have found someone to whom I can pass this card!
_________________
Dick Brenholtz
American living in Varel, Germany