SQL$HELP72.HLB  —  INSERT  Arguments  select-expr
    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.
Close Help