Rules for Indicator Variables - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

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

Rules for Indicator Variables

 

Number Contained in Indicator Variable

Specification to the Application

A negative number (most commonly ‑1)

The associated input main variable should be treated as a null. Alternatively, it means the Teradata Database returned a null for the associated column.

Zero

The associated input main variable is non-null or that a non-null value was successfully returned with no exception conditions applied.

A positive number

Truncation has occurred when returning a character or byte string to the associated main variable. This value represents the original length of the string before truncation.

An indicator variable is defined as a two byte integer (smallint). In PL/I, this is declared as:

DCL  identifier  FIXED BIN[ARY][(n)];

With this declaration, integer n must be positive, such that 1 <= n <= 15. If n is not specified, a default of 15 is used.