RE: query question

I've created a date control file that controls my queries. Only one
record. It has the current month, current fiscal month and year, and
some other data. I include it in my queries with or without a join
depending on the situation, then select on the relevant field (or just
use the join). That way I don't have to change hundreds of queries every
month, just one file and actually, there is an automatic procedure that
does that.  


Mark Walter
Senior Programmer/Analyst
IBM Certified RPG Developer
Hainey Business Systems
(717) 771-2362
mwalter@xxxxxxxxxxx
http://www.hbs-inc.com
 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
Sent: Thursday, March 30, 2006 3:18 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: query question

it is alpha, but w/it being a monthly can this be done in Query to run
every month and use the current month?

> If the field is numeric, you need to first change it to character.
>
> In a query,  digits(mmddyy)
> In RPGLE   AlphaMMDDYY = %EditC(mmddyy:'X');
>
>
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
>
>
>
>              steema@diskhaven.
>              com
>              Sent by:
To
>              rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx
>              midrange.com
cc
>
>
Subject
>              03/30/2006 02:55          query question
>              PM
>
>
>              Please respond to
>               RPG programming
>               on the AS400 /
>                   iSeries
>              <rpg400-l@midrang
>                   e.com>
>
>
>
>
>
>
> Hi I forget how to parse out a piece of a field. I can use a query 
> rather than RPG on one assignment but the date is mmddyy. I need to 
> parse out the year and then the month. I tried looking in the archives
to no avail.
> Thanks,
> Steve
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a 
> moment to review the archives at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a 
> moment to review the archives at http://archive.midrange.com/rpg400-l.
>
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.