|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.