This section lists language elements that are found in the syntax of many SQL statements.
For more information on the elements described here, see “Identifiers”, Chapter 4, “SQL Data Types,” “Search conditions”, “Expressions”, or “Strings”.
column-name An identifier that represents the name of a column.
condition An expression that evaluates to TRUE, FALSE, or UNKNOWN.
connection-name A string representing the name of an active connection.
host-variable A C language variable, declared as a host variable preceded by a colon.
indicator-variable A second host variable of type short int immediately following a normal host variable. It must also be preceded by a colon. Indicator variables are used to pass NULL values to and from the database.
number Any sequence of digits followed by an optional decimal part and preceded by an optional negative sign. Optionally, the number can be followed by an E and then an exponent. For example,
42 -4.038 .001 3.4e10 1e-10
owner An identifier representing the user ID who owns a database object.
role-name An identifier representing the role name of a foreign key.
savepoint-name An identifier that represents the name of a savepoint.
search-condition A condition that evaluates to TRUE, FALSE, or UNKNOWN.
special-value One of the special values described in “Special values”.
statement-label An identifier that represents the label of a loop or compound statement.
table-list A list of table names, which may include correlation names.
For more information, see FROM clause.
table-name An identifier that represents the name of a table.
userid An identifier representing a user name. The user ID is not case sensitive and is unaffected by the setting of the CASE RESPECT property of the database.
variable-name An identifier that represents a variable name.
