The sqlerrd(3) of the SQLCA indicates the number of rows inserted by the statement. If no rows are inserted (for example, if no rows satisfied the subselect search condition), the sqlcode variable of the SQLCA is set to 100.

If an INSERT statement attempts to add a duplicate key to a column that has a unique constraint, a duplicate key error is returned, the current transaction is aborted, and any open cursors are closed.