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