Specifies a select expression that specifies a result table.
The result table can contain zero or more rows. All the rows of
the result table are added to the target table named in the INTO
clause.
This is the only situation supported in SQL that allows you to
specify a second database in a single SQL statement.
The number of columns in the result table must correspond to the
number of columns specified in the list of column names. If you
did not specify a list of column names, the number of columns in
the result table must be the same as the number of columns in the
target table. For each row of the result table, the value of the
first column is assigned to the first column of the target table,
the second value to the second column, and so on.
You cannot specify a select expression in an INSERT statement
used to assign values to the segments in a column of the LIST OF
BYTE VARYING data type.
For detailed information on select expressions, see the Select_
Expressions HELP topic.