select-statement

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.

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:

common-table-expression
update-clause
read-only-clause
optimize-for-clause
isolation-clause (select-statement query)
lock-request-clause
concurrent-access-resolution-clause
offset-clause
fetch-clause
Retrieval of result sets from an SQL data change statement