Re: Month-end queries

[gogo400@xxxxxxxxx]

Well... nearly any Query/400 query can be converted into a well crafted
SQL statement without the hassle of a full blown RPGLE pgm.

-JA

> personally i would convert these to SQLRPGLE programs and use date
> functions for the comparison
>
> Thanks,
> Tommy Holden
>
>
>
> From:
> "Burns, Bryan" <Bryan_Burns@xxxxxxxxxxxx>
> To:
> <MIDRANGE-L@xxxxxxxxxxxx>
> Date:
> 04/30/2009 09:21 AM
> Subject:
> Month-end queries
> Sent by:
> midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> 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.
>
>
>
> --
> 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.