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 |