Roll Back Rows
By default, copying data stops after finding an error. If you do not want to back out the rows already copied, specify with WITH ROLLBACK=DISABLED. For example:
COPY TABLE personnel
(name = CHAR(0),
dept = CHAR(0)nl)
FROM 'pers.data'
WITH ROLLBACK = DISABLED;
Use the WITH ROLLBACK clause on the COPY FROM statement only. Rows are never backed out of the copy file if copy into is terminated. For more information, see the SQL Reference Guide.