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