Variables (Entity SQL)
A variable expression is a reference to a named expression defined in the current scope. A variable reference must be a valid Entity SQL identifier, as defined in Identifiers (Entity SQL).
The following example shows the use of a variable in the expression. The
c in the FROM clause is the definition of the variable. The use of
c in the SELECT clause represents the variable reference.
select c from LOB.customers as c