Indicator Variables and Output - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Indicator variables can be associated with the output main variables used in the INTO clause of a data returning statement or cursor FETCH statement.

Value Returned from the Database Action Taken
Null for a column and no indicator variable exists The SQLCODE in the SQLCA is set to -305 and the value of the receiving main variable remains unchanged.
Negative value The field is returned to the main variable with no exception conditions.
Positive value The returned byte or character string is truncated.
EXEC SQL
      SELECT col1
         INTO  :hostvar1 :indvar1
         FROM  table1
         WHERE col1 = :hostvar2;
EXEC SQL
         FETCH cursor1 INTO :hostvar1 :indvar1;