Host 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

Host Variables

SQL statements can use C variables for sending input values to, and receiving output values from, the Teradata 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 SQL Stored Procedures and Embedded SQL (B035‑1148).