Reader Feedback and Insights: Thanks for the Tips

September 20, 2002 Timothy Prickett Morgan

Hey, Ted:

I appreciate the tips and techniques that you provide in Midrange Guru, OS/400 Edition. It’s nice to get a few tips each day and try them out rather than be inundated with a bunch at one time.

— Lori

Sponsored By ADVANCED SYSTEMS CONCEPTS

SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution: Windows, Web or host user interfaces Convert AS/400 data into PC file formats E-mail or FTP query results, reports and spool files Run-time prompted queries and reports for end users IF-THEN-ELSE logic in queries and reports Report, form

Comparing Lists of Numbers to a Value

September 20, 2002 Timothy Prickett Morgan

Hey, Ted:

It’s a shame you can’t do something like this in RPG:

* if any of the fields > 25
If       (field1 or field2 or field3) > 25 
         etc
Endif

* if all three fields > 25)
If       (field1 and field2 and field3) > 25 
         etc
Endif

— David

Who says you can’t, David? You just have to do it a different way. You know, cogitate external to the rectangular container constructed of corrugated paper.

Many programming languages have minimum and maximum functions, which return one value from a list. OPNQRYF and Microsoft Excel come to mind.

Below is

JD Edwards Dates, Revisited

September 20, 2002 Timothy Prickett Morgan

Dear Readers:

After I published the piece on how to convert JD Edwards date to DB2 date data types, I received more mail than I have ever received before.

Obviously, you guys are salivating for date routines. Well, so as not to let you down, I will publish in this issue a user-defined function that you can use in place of the date conversion formula. However, for those of you that do not have V5 or the C Compiler and SQL Development Kit, I will provide instructions on how you can download a working version of the function and