Description

The result table is derived by evaluating the isolation-clause, from-clause, where-clause, group-by-clause, having-clause, order-by-clause, fetch-first-clause, and select-clause, in this order.

See Queries for a description of the select-clause, from-clause, where-clause, group-by-clause, having-clause, order-by-clause, fetch-first-clause, and isolation-clause.

INTO variable,...
Identifies one or more host structures or variables that must be declared in the program in accordance with the rules for declaring host structures and variables. In the operational form of the INTO clause, a reference to a host structure is replaced by a reference to each of its variables. The first value in the result row is assigned to the first variable in the list, the second value to the second variable, and so on. The data type of each variable must be compatible with its corresponding column.