References to variables

A variable in an SQL statement specifies a value that can be changed when the SQL statement is executed. There are several types of variables used in SQL statements.

host variable

Host variables are defined by statements of a host language. For more information about how to refer to host variables, see References to host variables.

parameter marker

Parameter markers are specified in an SQL statement that is dynamically prepared instead of host variables. For more information about parameter markers, see Parameter markers in the PREPARE statement.

Unless otherwise noted, the term host variable in syntax diagrams is used to describe where a host variable or parameter marker can be used.