A DB2 term for a program variable in an application program. Host variables are used in SQL commands.
In a DB2 UDB for iSeries SQL application program, a variable referred to by embedded SQL statements. In RPG, this is called a field name; in C, this is known as a variable; in COBOL, this is called a data item.
a C program variable that you use in an embedded SQL statement
an area of storage allocated by the host language and referenced in an SQL statement
an automatic variable unless you explicitly define it as an external or static variable
a scalar or aggregate variable declared in C and shared with Oracle, meaning that both your program and Oracle can reference its value
a variable you declare in a host environment, then pass to one or more PL/SQL programs, which can use it like any other variable
or COBOL program variable that is referenced in an embedded statement. A host variable is identified by the dollar sign ( $ ) or colon ( : ) that precedes it.