15.10 - Indicator Variables - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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

PP2 uses indicator variables to show nullness of a field sent to or returned by the Teradata Database, as well as 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).