Indicator Variables

Go Up to Executing a Procedure

Both input parameters and return values can have associated indicator variables for tracking NULL values. You must use indicator variables to indicate unknown or NULL values of return parameters. The INDICATOR keyword is optional. An indicator variable that is less than zero indicates that the parameter is unknown or NULL. An indicator variable that is 0 indicates that the associated parameter contains a non-NULL value. For more information about indicator variables, see Working with Data.