Re: Generate temporary table/list of dates

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Look at  WITH to create a "table" with a secuence of numbers, select 
them and add them to you base date.
I don't remeber the sintax, but you can combine two tables from 1 to 10 
to get one from 1 to 100...

Pete Helgren wrote:

> Clarification: With SQL
>
> Pete Helgren wrote:
>  
>
> > I would like to generate a list of valid dates within a given range of 
> > date on the fly, if possible.  I am running V5R3M0.  I found a couple of 
> > examples out in cyberspace but couldn't get them "translated" into 
> > DB2/400 syntax.  One used a recursive CTE which I don't think is 
> > supported on V5R3M0.
> >
> > Anybody got something like this?  I'd rather not create a table and 
> > populate it if I can avoid it (unless it is a temporary table discarded 
> > after the query runs).
> >
> > Thanks,
> >
> > Pete
> >
> >  
> >