Re: DB2 CASE select : more than 1 result columns

this looked like a fun question to ask copilot AI, not bad...


<ai>
In this example, you have two separate CASE statements, but each CASE statement is applied to the column type without repeating the conditions. Unfortunately, you can't directly merge these into a single CASE statement because they produce different values for col1 and col2.

It might feel like repetition, but each column's logic is isolated for clarity and simplicity. If you have additional logic or if you're calculating more values based on type, sticking with separate CASE statements can keep it straightforward and maintainable.
</ai>


VERNON HAMBERG Owner via MIDRANGE-L wrote on 11/5/2024 12:23 PM:

Hi


It looks like you want to have 2 columns - a CASE can result in only 1 column, so I think you need them separate.


Or am I missing something simple? :)


Cheers
Vern


On Tue, 5 Nov, 2024 at 9:30 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

To: midrange systems technical discussion

Hello,

Can I merge these statements into 1 CASE statement or do I need to repeat
the conditions as below?
Thanks

CASE
type
WHEN '1' THEN '1A'
WHEN '2' THEN '1B'
ELSE ' '
END col1

CASE
type
WHEN '1' THEN '2A'
WHEN '2' THEN '2B'
ELSE ' '
END col2