Meaningful Names for Null Indicators
October 29, 2008 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? Since RPG variables cannot be null, SQL loads two-byte (five-digit) integer variables with |
