Re: SQL build file of dates

Billy:

<snip>
 What is the format of the database file you want to select from?
   Do you have any indexes( i.e. keys ) over it?
</snip>

That's my problem...I'm not selecting from a file...I can pass a parm or
substitution value into a QMQRY that contains a start date (or year and
month), but I'm not selecting "from" anything.  Perhaps that makes it
impossible to do in SQL.

In a HLL program I can do a loop and increment from a passed-in value, but
I'm trying to see if there is an SQL way of doing the same.  From what I
have been able to determine from the manuals and previous experience, a
"select" statement requires a "from" clause, which requires a file...and I
don't have an input file.

If this is out of the realm of possibility for SQL...that's fine.  The right
tool for the right job, and all that.  But since most of the rest of this
particular process is a series of QMQRYs, I thought it would be good to be
consistent.

Thanks,
--Bruce Guetzkow