You can assign a null to a column of any data type if the column was defined as a nullable column. You can also assign a null to a host language variable if there is an indicator variable associated with the host variable. (For more information about indicator variables, see Indicator Variables.)

To ensure that a null is not assigned to a column, you can use Ifnull.