Host Variables - 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

SQL statements can use C variables for sending input values to, and receiving output values from, the database. Variables used in this manner are called host variables. Host variables allow an application to use the same statement in an iterative fashion, obtaining results based on the value of the variable when the statement is executed.

PP2 supports structured host variables to a depth of two, following the same rules as SQL/DS and DB2.

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