retrieving dates from 2 sets of dates

Whilst @Håkan Winther is right in that this is a MS-SQL Server site, maybe we can still point you in the right direction for the solution.

What you need to do is expand the days between start and finish. This can be done using a numbers or tally table.

I have managed this through the use of a common table expression (the code starting with "WITH"). This just generates a list of integers, starting with 0. I then multiply the original data using the inner join, driving the join by calculating the difference in days between the start and end of leave entry.

In your example the leave is 3 days, so three rows are generated. I then create a final column that turns the row number into the actual date that the row represents.

Take a look at the code, I have no idea how it would translate to DB2, but I think the general idea should be translatable.

DECLARE @TestTable AS TABLE
    (START_DATE datetime,
     END_DATE datetime,
     LEAVE_NAME varchar(20))
INSERT  INTO @TestTable
        (START_DATE,
         END_DATE,
         LEAVE_NAME)
VALUES  ('2011-08-01',
         '2011-08-03',
         'Casual Leave') ;
WITH    nums
          AS (SELECT TOP 1000
                        ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 AS N
              FROM      sys.all_columns AC
              CROSS JOIN sys.all_columns AC2)
    SELECT  START_DATE,
            END_DATE,
            LEAVE_NAME,
            DATEADD(DAY, n, START_DATE)  AS CurrDate
    FROM    @TestTable TT
    INNER JOIN nums ON nums.n <= DATEDIFF(day, tt.START_DATE, tt.END_DATE)