Queries

A query specifies a result table or an intermediate table. A query is a component of certain SQL statements. A query can have one of three forms.

A subselect is a subset of a fullselect, and a fullselect is a subset of a select-statement.

Authorization describes the privilege set that is required to use any form of a query.

Another SQL statement that can be used to retrieve at most a single row is described in SELECT INTO. SELECT INTO is not a subselect, fullselect, or a select-statement.

Authorization
For any form of a query, the privilege set that is defined below must include one of the following:
subselect
The subselect is a component of the fullselect. A subselect specifies a result table that is derived from the tables or views that are identified in the FROM clause.
fullselect
The fullselect is a component of the select-statement, ALTER TABLE statement for the definition of a materialized query table, CREATE TABLE statement, CREATE VIEW statement, DECLARE GLOBAL TEMPORARY TABLE statement, INSERT statement, UPDATE statement, and MERGE statement.
select-statement
The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can also be issued using SPUFI or the command line processor which causes a result table to be displayed at your terminal. In any case, the result table specified by a select-statement is the result of the fullselect.

Parent topic: SQL: The language of DB2

Related concepts:

Types of tables

Temporal tables and data versioning