We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!
Possible clauses and additions of a subquery after the addition FROM of the statements INSERT and MODIFY. These clauses define a result set, which is used as a data source of the INSERT or INSERT statement.
Apart from the client column, the result set of the subquery must have at least as many columns as the primary key of the database table or the DDIC table view that is filled using the INSERT statement or modified using the MODIFY statement. It cannot, however, have more columns than the target DDIC database table or view .
The following special rules apply:
A further subquery within the subquery cannot access the table or view processed using the INSERT or MODIFY statement.
Insertion of columns of a result set formed by an inner join in a database table.