Using the SQL statement reference
378
Using the SQL statement reference
This section describes some conventions used in documenting the SQL
statements.
Common elements in SQL syntax
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"
on page 223, "SQL Data Types" on page 263, "Search conditions" on
page 239, "Expressions" on page 230, or "Strings" on page 224.
♦
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.
♦
data-type A storage data type.
♦
expression An expression.
♦
filename A string containing a filename.
♦
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.
To Next Page
Loading...