Fred, Philip thanks for your help.

I'm not using the time provided by DB2 because the advice from Ralph
Kimball:

"Most data warehouses need an explict time dimension even though the
primary time key may be an SQL date-valued object. The explicit time
is needed to describe fiscal periods, seasons, holidays, weekends, and
other calendar calculations that are difficult to get from the SQL
date machinery"

Thanks again,

Carlos