Using indicator variables

You can associate indicator variables with host variables to indicate when a database value is null. Use a space and, optionally, the indicator keyword, to separate each indicator variable from the host variable with which it is associated. Each indicator variable must immediately follow its host variable.

Without indicator variables, Embedded SQL cannot indicate null values.