DB2 SQL-Error: -20165
SQLState: 428FL
Short Description: INSERT STATEMENT WITHIN A SELECT IS NOT ALLOWED IN THE CONTEXT IN WHICH IT WAS SPECIFIED C S T P C INSERT SELECT SELECT INTO E INSERT FROM FROM V NOT ATOMIC INSERT ATTRIBUTES PREPARE
An atomic INSERT statement can be specified in the FROM clause of a SELECT in specific contexts. It is only allowed as the only table-spec in the FROM clause of a SELECT statement (excluding the common table expressions) that is a subselect or a SELECT INTO statement. The INSERT statement must not include the NOT ATOMIC clause.