Appendix G. 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 terms.

Table 175. 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 176. 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

[ Top of Page | Previous Page | Next Page | Contents |
Index ]