The select-statement is
the form of a query that can be specified in a DECLARE CURSOR statement,
either directly, or prepared and then referenced. It can also be issued
through the use of dynamic SQL statements, causing a result table
to be displayed on the user's screen.
The table specified by a select-statement is
the result of the fullselect.
>>-+-----------------------------------+--fullselect--●--------->
| .-,-----------------------. |
| V | |
'-WITH----common-table-expression-+-'
>--+------------------+--●--+---------------------+--●---------->
+-read-only-clause-+ '-optimize-for-clause-'
'-update-clause----'
>--+------------------+--●-------------------------------------->
'-isolation-clause-'
>--+-------------------------------------+--●------------------><
'-concurrent-access-resolution-clause-'
The authorization for a select-statement is
described in the Authorization section in "SQL queries".
For details about the clauses in the select-statement
query, refer to the following topics:
DB2 10.5 for Linux, UNIX, and Windows