Es geht auch anders, aber so geht es auch:
Code:create table qgpl/td (woche dec(2), menge dec(5)) insert into td values(1, 10) insert into td values(3, 30) with recursive w (wo) as (select 1 from sysibm/sysdummy1 union all select wo+1 from w where wo < 53) select wo, coalesce(menge, 0) from w left outer join td on wo = woche order by wo
Bookmarks