SQL Reference

Queries

A query specifies a result table.

A query is a component of certain SQL statements. The three forms of a query are:

• subselect
• fullselect
• select-statement.

There is another SQL statement that can be used to retrieve at most a single row described under SELECT INTO.

Authorization

For each table or view referenced in the query, the authorization ID of the statement must have at least one of the following:

• SYSADM or DBADM authority
• CONTROL privilege
• SELECT privilege.

Group privileges are not checked for queries contained in static SQL statements.

For nicknames referenced in a query, there are no privileges at the federated database to be considered. Authorization requirements of the data source for the table or view referenced by the nickname are applied when the query is processed. The authorization ID of the statement may be mapped to a different remote authorization ID.