SQL$HELP72.HLB  —  SELECT  Singleton Select, Arguments

1  –  INTO

    Syntax options:

       INTO parameter
       INTO qualified-parameter
       INTO variable

    Specifies a list of parameters, qualified parameters
    (structures), or variables to receive values from the columns
    of the one-row result table. The variables named must have been
    declared in the host program. If a variable named in the list
    is a host structure, SQL considers the reference the same as a
    reference to each of the elements of the host structure.

    If the number of variables specified, either explicitly or by
    reference to a host structure, does not match the number of
    values in the row of the result table, SQL generates an error
    when it precompiles the program or compiles the SQL module file.

    If columns in the result table from a singleton select include
    null values, the corresponding parameters must include indicator
    parameters.

2  –  select-list

    For a description of select lists, see the Select_Expressions
    HELP topic.
Close Help