Re: AW: Week of the year routine

["M. Lazarus" <mlazarus@xxxxxxxx>]

Birgitta,

 I was aware of that, but in this shop both 
machines do not have the SQL feature.  I don't 
want to introduce code that can't be compiled on their machine.

 -mark


At 4/15/2011 01:06 PM, you wrote:
> Mark,
>
> Even though SQL is not installed on a machine, 
> the SQL runtime is always available.
> If you write a small RPG program (or procedure 
> within a service program) with embedded SQL 
> using the SQL scalar function WEEK to determine 
> the week in the way you described, compile it on 
> a machine with SQL and transfer the compiled object, it will run.
>
> Mit freundlichen Grü�en / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll 
> land among the stars." (Les Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and 
> losing them? Not training them and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Henrik Rützou
> Gesendet: Friday, 15. April 2011 18:39
> An: RPG programming on the IBM i / System i
> Betreff: Re: Week of the year routine
>
> Mark,
>
> this is not an easy task, first of all - weekday no 1 is in US sunday and in
> most europe monday,
> second 1. january could be week 52/53 in previous year it all depends on
> what weekday 1. january
> are
>
> On Fri, Apr 15, 2011 at 6:23 PM, M. Lazarus <mlazarus@xxxxxxxx> wrote:
>
> >  Before I reinvent the "calendar file" wheel, does anyone have an
> > *RPG* routine that will calculate the week of the year.
> >
> >  A few parameters:
> >
> > - This machine is on an older OS version (5.3) and does not have the
> > SQL feature installed.
> >
> > - Week 1 of the year starts on January 1.  So, for example, in 2010,
> > Dec. 26-31 would be the last week of the year (53?).  Saturday, Jan
> > 1, 2001, is week 1.  Monday, Jan 2-8, is week 2, etc.
> >
> >
> >  Thank you.
> >
> >  -mark