Indicator Variables - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
17.20
Published
April 2023
ft:locale
en-US
ft:lastEdition
2023-04-21
dita:mapPath
neh1679404006646.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
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, in a WHERE clause).

PP2 uses indicator variables to show nullness of a field sent to or returned by the database, as well as truncation of a character or byte string when placed into the corresponding main variable.

Indicator variables are documented in Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.