RE: query question

Just my 2 cents worth...I never put any Query/400 queries in
production...those are generally for one-off deals.  If it's going to be
run as a production object the preference is to always write a
program... 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
Sent: Thursday, March 30, 2006 2: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.
>
>