As long as we are discussing JD Edwards running on DB/2. Here's another potentially useful function. This one converts a value from one unit of measure to another based on the F41002 table. It does this by converting the FromUOM to the primary UOM and thence to the ToUOM.
During nine years of blackguarding the J. D. Edwards date format (also known as JDate, also misnamed Julian Date), I have resisted learning to write DB/2 stored procedures because the need to use them while developing OneWorld applications is minimal and OneWorld is the only context in which I have encountered DB/2. Well, I have finally encountered that special confluence of necessity and available time that produces a tool -- in this case a function. I broke down, I learned, and I wrote that JDate to DB/2 Date function. Here is that code, in case you should find it useful:
We here at Deft Flux have always preferred Unix style operating systems and commands to Microsoft. The problem was that our clients always use Microsoft operating systems and until recently, it was always too much of a hassle to get gnu utilities up and running on a Microsoft workstation, especially when you're moving to a new one every few months. Well, since the good folks at gnu started compiling programs for windows and providing installation programs (to cover dependancies), we decided every workstation needs gnu utilities. First, we install gvim because it is the best text editor ever written. Then we install grep, core utilities, and finally sed. Thus we have assembled, on a Microsoft workstation, a group of what are arguably the most useful programs ever written, pound for pound.