Re: Month-end queries

[Alan Campin <alan0307d@xxxxxxxxx>]

If you are talking Query/400, none. The better solution is to use STRQM and
create queries with parameters.

You can use command

RTVQMQRY QMQRY(Q400QRY) SRCFILE(ALANC/QSRCF) SRCMBR(Q400QRY) ALWQRYDFN(*YES)

to retrieve the SQL and use

RTVQMFORM QMFORM(Q400QRY)  SRCFILE(ALANC/QSRCF) SRCMBR(Q400QRY)
ALWQRYDFN(*YES)

to retrieve the form. This assumes you have STRQM.

You can then pass parameters to the query from a CL. If you interested, I
have some code that does this.




On Thu, Apr 30, 2009 at 8:23 AM, Burns, Bryan <Bryan_Burns@xxxxxxxxxxxx>wrote:

> At the end of every month, I change the record selection date range in 15
> or so queries to reflect the current month in order to get month-end totals.
>  Is there a way to automate this?  Of course, the files to be queried may be
> different so the date fields will not always be the same.
>
> Bryan Burns
> iSeries Specialist
> ECHO, Incorporated
> Lake Zurich, Illinois
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.