CASE Expression with Multiple Entries

revel · Posted: Thu Jun 30, 2011 1:00 pm

Hi All,

Could you please give me a query for following scenario.

I have a table with Plan information with multiple coverage

Ex;

PLAN1 PAIDAMOUNT1 COVERAGE1
PLAN1 PAIDAMOUNT2 COVERAGE2

I have to derive Coverage Code based on input variable like

GuyC · Posted: Thu Jun 30, 2011 1:31 pm

a case is supposed to give a scalar result.
The normal way to solve this, is to create two hostvariables or a hostvariable array.

revel · Posted: Thu Jun 30, 2011 2:12 pm

Hi,

I want to derive within CASE Expression becuase i need to derive Coverage code based on input Cobol Variable for around 30 coverages.

Just for augment sake i gave u an example.

Let me know, if you have any alternatives.

Regard's
Raghu

GuyC · Posted: Thu Jun 30, 2011 2:35 pm

it is irrelevant if it is for 1 or 30
Or you have a big case in DB2 or a big evaluate in COBOL

unless there is programmable logic in the derivation process.
something like where posstr(:RQ-COV-CD,COV_CD ) > 0

revel · Posted: Thu Jun 30, 2011 2:53 pm

Hello,

This is how we have designed for our Project. If you know answer

Please Suggest, more over it is SP, i didn't see any fault design in this.

GuyC · Posted: Thu Jun 30, 2011 3:31 pm

SP is meaningless , SP can be (almost any language)
You seem certain the design is correct, yet you don't find an answer to your requirement but you just know using a CASE instruction will solve it.

somehow I don't think I can help you.
Maybe someone else can.

revel · Posted: Thu Jun 30, 2011 3:43 pm

Hello...

This is not some kind of Adhoc/small changes Request. We are integrating Front end with Mainframe backend.

We r deing hard to know answere for this..

I appreciate for your suggestion using cobol evaluate but that was my ultimate solution..but i am looking forward to have within CASE expression as Query is running remotly

Thanks your suggestion. let others can help me out

Thank you

Bill Woodger · Posted: Thu Jun 30, 2011 6:53 pm

You're looking for help. Someone of great skill and experience replies to your request.

Instead of taking any notice of the advice, which is your call, you felt the need to stick with your design, and subsequently to justify that by aggrandising your system. It doesn't matter if it is a one-off for a one-record dataset or a system to save the planet - if it doesn't work, it doesn't work.

Maybe get hold of a copy of the manual and explain to that how important your system is. Or call IBM, I'm sure they'll have it fixed in a jiffy, once they know how important it is.

My advice for your system is to use code that works. If you need help to do that, then you'll need to know how to ask for help, and how to respond if you can't understand it, or how it applies.

Just sitting there and letting the world know how important you and your system are will lead nowhere. You choice.

dbzTHEdinosauer · Posted: Thu Jun 30, 2011 8:56 pm

you simply cannot generate an IN List with literals greater than 1 item.

now, you can generate an IN List with a SELECT.
maybe your cobol program
(if you SP is an only sql sp and not a cobol program)
can load the potential IN List items into a table (GTT or regular table) prior to invoking the SP.

to be nice, I will say that part of your design failed to take into consideration technical aspects.

or

i could maintain a tone that you deserve and say that your mouth overloaded your ass.