Calculate a Fractional Number of Years Difference Between Two Dates in SQL
Hey, Mike:

Is there anything new in SQL that will calculate the difference between two dates and return a fractional number of years? For example: "2007-09-10"--"1997-01-01" should return 10.69 years. READ MORE >

Meaningful Names for Null Indicators
by Ted Holt

There are two ways that a column of a SQL result set can contain the null value. One, it can be derived from an expression that contains a null value. Two, null is returned in outer joins and exception joins when a row in a primary table has no match in a secondary table. In either event, RPG has no way to represent a null value, so what's a guy (a professional i-on-Power guy, that is) to do when an embedded SQL command might return null values? READ MORE >