Re: SQL function WEEK_ISO for years beyond 2039

Thanks for the input.



I did try to set the environment value as:



ADDENVVAR ENVVAR(QIBM_QBASEYEAR) VALUE(1970) LEVEL(*SYS)



And restart the job, recompile the program and run again.



Alas same result.



The problem is that while the date variable in the program is "DATE(10)" the
variable in the SQL structure created by the pre-compiler is DATE(8). Thus
the problem seems unsolvable.



I guess that I will simply resign to making the program work up until 2039
(at a time where I will most definitely be retired) and send out a warning
that if run beyond that time the calendar file will have to be maintained
manually.



/Ake/