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.

The normal DB2 SQL function to return a difference between two timestamps (TIMESTAMP_DIFF) will not return fractional values as your calculation requires.

However, if super accuracy isn’t a great need, there is an easy way to do this. Simply calculate the number of days between the two dates to get the number of days difference. Then divide the result by 365.2425, which is the average number of days in the Gregorian calendar,

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?

Since RPG variables cannot be null, SQL loads two-byte (five-digit) integer variables with

I have a problem with duplicate 5250 sessions. On our sessions, we change the default screen display font to another font size, such as Courier New. However when we start a second session with the same iSeries Access workstation profile, the screen font reverts back to its default font size: a regular IBM3270 font. What’s going on here and why can’t I use a different font size on multiple sessions?

–Jean-Pierre

To solve this problem, I went with my default philosophy for debugging computer issues.

IF I CAN DUPLICATE IT, I CAN SOLVE IT!!!

Unfortunately things don’t always work out