Specifies a result table. A result table is an intermediate table
    of values derived from columns and rows of one or more tables or
    views that meet conditions specified by a select expression.
    The tables or views that the columns and rows come from are
    identified in the FROM clause of the statement.

    The basic element of a SELECT statement is called a select
    expression. The Select_Expressions HELP topic describes select
    expressions in detail.

    To retrieve rows of a result table in host language programs,
    you must use the DECLARE CURSOR statement or a special form of
    SELECT statement called a singleton select. A singleton select
    statement specifies a one-row result table, and is allowed in
    either precompiled programs or as part of a procedure in an SQL
    module. A singleton select includes an additional clause, INTO,
    to assign the values in the row to host language variables in a
    program.

    For information on the general form of the SELECT statement, see
    the SELECT General_Form statement.