Use indicator variables:
- when the application requires the database to set a column null, such as when executing an INSERT or UPDATE statement.
- within a WHERE clause condition with host variables to handle a null.
Indicator Variable Value | Description |
---|---|
negative | The value in the associated main variable is ignored. PP2 sends a null to the database for the column. |
zero or positive | The host variable value is sent to the database as the column value. |
For example:
EXEC SQL INSERT table1 VALUES (:hostvar1 :indvar1); EXEC SQL UPDATE table1 SET col1 = :hostvar1 :indvar1 WHERE col1 = :hostvar2;