*TODAY for World writer if at releases older than A73 SP 13

[Eric Lehti]

If you are on an A73 release, SP 12 or older, you are missing out on the *TODAY capability that World writer has had since A73 service pack 13. It is SAR Number 313744, dated 1991-05-06

But if you are not upgrading to a current release of JDE for awhile, here is one work-around that will give you a partial implmentation (but not the DATE arithmetic capability to add and subtract days).
SOLUTION: every morning immediately after midnight, populate a one-record file with TODAY's record from F00365.
Name it something like F00365C (current date).

In all your World Writers that you want to select data having TODAY's date, join to F00365C. It is not necessary to do date selection at all. The join to F00365C takes care of the that.
But all of us really ought to upgrade to World A91 *TODAY, and not linger behind with old technology!

 

[Eric Lehti]

In my previous post, the file containing one record only with TODAY's date should be named F55365, not F00365C, so as to conform to JDE's file-naming recommendations.

 

[Eric Lehti]

Also, compile F55365 to your JDE security library that all environments share. That enables your production, TEST, and DEVELOPMENT environments to get *TODAYs value for today.

And let's upgrade to A91 SOON, *TODAY if possible!

 

[szmyd]

We're on cume 11 and have that functionality. It's available through an update. There is no requirement to be on cume 13 or higher.