Re: DB2 CASE select : more than 1 result columns

[VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>]

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