Terminology differences

Some terminology used in the ANSI and ISO standards differs from the terminology used in this book and other product books.

The following table is a cross reference of the SQL 2003 Core standard terms to DB2® SQL

Table 1. ANSI/ISO term to Db2 SQL term cross-reference
ANSI/ISO Term
Db2 SQL Term
literal
constant
comparison predicate
basic predicate
comparison predicate subquery
subquery in a basic predicate
degree of table/cursor number of items in a select list
grouped table
result table created by a group-by or having clause
grouped view
result view created by a group-by or having clause
grouping column
column in a group-by clause
outer reference
correlated reference
query expression
fullselect
query specification
subselect
result specification
result
set function
aggregate function
table expression
 
→──from─clause──┬──────────────┬───────────→
                └─where─clause─┘
→──┬─────────────────┬──┬───────────────┬──→
   └─group─by─clause─┘  └─having─clause─┘
target specification
host variable followed by an indicator variable
transaction
logical unit of work or unit of work
value expression
 arithmetic expression

The following table is a cross reference of Db2 SQL terms to the SQL 2003 Core standard terms.

Table 2. Db2 SQL term to ANSI/ISO term cross-reference
Db2 SQL Term
ANSI/ISO Term
aggregate function
set function
arithmetic expression
value expression
basic predicate
comparison predicate
column in a group-by clause
grouping column
correlated reference
outer reference
 
→──from─clause──┬──────────────┬───────────→
                └─where─clause─┘
→──┬─────────────────┬──┬───────────────┬──→
   └─group─by─clause─┘  └─having─clause─┘
table expression
fullselect
query expression
host variable followed by an indicator variable
target specification
logical unit of work or unit of work
transaction
interactive SQL
direct SQL
number of items in a select list degree of table/cursor
result
result specification
result table created by a group-by or having clause
grouped table
result view created by a group-by or having clause
grouped view
subquery in a basic predicate
comparison predicate subquery
subselect
query specification
subselect or fullselect in parenthesis
query term