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.