Indicator Variables - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Indicator variables can be used with main variables intended for I/O, although certain indicator variables cannot be used for input (for example, those appearing in a WHERE clause).

PP2 uses indicator variables to handle nulls sent to or returned from the Teradata Database or truncation of a character or byte string when placed into the corresponding main variable.

Indicator variables are documented in SQL Stored Procedures and Embedded SQL (B035‑1148).