RE: Null in SQL select union

[CWilt@xxxxxxxxxxxx]

It makes no sense, but this works for me...

select                                
  case                                
    when 1 <> 2 then NULL             
    else 0                            
  end as testnull,                    
  current_date 
from sysibm/sysdummy1  


Charles

> -----Original Message-----
> From: Titus Kruse [mailto:t_kruse@xxxxxxxxx]
> Sent: Thursday, March 25, 2004 6:08 AM
> To: Midrange L
> Subject: Null in SQL select union
> 
> 
> Hi!
> 
> I want to execute two queries combined with UNION. In columns 
> without a
> value, I wand to have null for default. When sorting the 
> resulting query,
> rows with null in group-fields and a value in result-fields 
> should be placed
> after those with a value in group-fields.
> 
> Here is my example:
> 
> SELECT type, color, NULL AS number FROM cars
> UNION SELECT NULL AS type, NULL AS color, COUNT(*) FROM cars
> GROUP BY type
> ORDER BY type, color
> 
> But this will not be executed because of errer "NULL is not a 
> column of
> cars".
> 
> How do I specify a null-value in a SELECT-clause?
> 
> 
> 
> Titus Kruse
> Software-Entwicklung IBM iSeries
> ESW Software Warda KG (GmbH & Co.)
> Telefon: +49.40.682893.22
> Telefax: +49.40.682893.28
> E-Mail: t_kruse@xxxxxxxxx
> Web: www.esw-kg.de
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>