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
| 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.
| 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
|