Indicator Variables and Input
Use indicator variables:
Indicator Variable Value |
Description |
negative |
The value in the associated main variable is ignored. PP2 sends a null to the Teradata Database for the column. |
zero or positive |
The host variable value is sent to the Teradata 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;