Filling in missing dates DB2 SQL
===

My initial query looks like this:

    select process_date, count(*) batchCount
    from T1.log_comments 
    order by process_date asc;

I need to be able to do some quick analysis for weekends that are missing, but wanted to know if there was a quick way to fill in the missing dates not present in `process_date`.

I've seen the solution [here][1] but am curious if there's any magic hidden in db2 that could do this with only a minor modification to my original query.  


  [1]: http://stackoverflow.com/questions/5059380/filling-gaps-in-dates-returned-from-database-pure-sql-solution-possible