Stop or Continue the Copy
Use the WITH ON_ERROR clause to stop or continue copying the data when an error occurs. In the following example, the copy continues after finding an error:
COPY TABLE personnel
(name= CHAR(0),
dept = CHAR(0)nl)
FROM 'pers.data'
WITH ON_ERROR = CONTINUE;
The default is to terminate at the first error.