ASA SQL Reference
SQL Statements
Using the SQL statement reference
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, 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.
data-type A storage data type.
expression An expression.
filename A string containing a filename.
hostvar A C language variable, declared as a host variable preceded by a colon. See Using host variables for more information.
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.
variable-name An identifier that represents a variable name.