15.10 - Host Variables - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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).