As you all should know by now, version 10 of DB2 for z/OS greatly expands support for indicator variables. Those of you who write programs that must handle results that could be null should know what an indicator variable is. Basically, DB2 represents null in a special variable known as an indicator. An indicator is defined to DB2 for each column that can accept nulls. The indicator variable is transparent to the end user, but must be provided for when programming in a host language (such as COBOL or PL/I). If the indicator variable is less than zero, then the column to which it applies has returned NULL.

site DesignBy KaraIT