I just stumbled upon this olap function and wondered why the "NULLS
FIRST/LAST" clause is not possible in normal order by but only using
row_number() over(). Sure, I can do a
SELECT *, row_number() over(ORDER BY col1 ASC NULLS FIRST) AS rn FROM
tab1 ORDER BY rn
to get what I want, but its awfully complicated. (Interestingly, the
optimizer rewrites above order by in an ugly ORDER BY CASE WHEN col1
is NULL THEN 0 ELSE 1, col1)

Anyone could shed any light on this? Will the functionality maybe
available in future versions of DB2 (or maybe it is already, just not
in LUW)?

Regards,
Janick