Is it possible to return multiple column on single CASE evaluation in DB2?
below query return single column.

```
select (case when 1=1 then 0 else 1 end) as col from table;

```

I need multiple column like

```
select (case when 1=1 then 0 as col, 1 as col1 else 2 as col1 , 3 as col2 end) from table;
select (case when 1=1 then 0,1 else 2, 3  end)col , col1 from table;

```

Is coalesce function is use full for above conditions? thanks.