-30106   INVALID INPUT DATA DETECTED FOR A MULTIPLE ROW INSERT OPERATION. INSERT PROCESSING IS TERMINATED

Explanation

An error was detected with the input data for one row of a multiple row insert operation. No further rows will be inserted. For an atomic operation, all inserted rows are rolled back. For a non-atomic operation, rows inserted successfully before the row containing the invalid input data was encountered are not rolled back.

System action

The statement cannot be processed.

Programmer response

Correct the row containing the invalid input data and submit the multiple-row INSERT statement again for the rows that did not get inserted.

SQLSTATE

22527