I have one oracle query and i want to have the same functionality in DB2 version 10.5.5.
The query is select * from (
SELECT trunc(sysdate+LEVEL-1) w_date
where to_char((sysdate+LEVEL-1),'DY') not in ('SAT','SUN')
CONNECT BY LEVEL <= 2100)
The problem is DB2 is not allowing to have arithmatic operation with dates.