Some terminology used in this manual may differ from the terminology used
in other SQL products. The terminology used in the DB2 Server for VSE
& VM manuals may change in the future.
The following tables cross-reference ISO-ANS SQL(89) terms to DB2
Server for VSE & VM terms.
ISO-ANS SQL(89) Term
|
DB2 Server for VSE & VM Term
|
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
|
query term
|
subselect or fullselect in parentheses
|
result specification
|
result
|
set function
|
column function
|
sort specification
|
order-by clause specification
|
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
|
DB2 Server for VSE & VM Term
|
ISO-ANS SQL(89) Term
|
arithmetic expression
|
value expression
|
basic predicate
|
comparison predicate
|
column function
|
set function
|
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
|
number of items in a select list
|
degree of table/cursor
|
order-by clause specification
|
sort specification
|
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 parentheses
|
query term
|