5. Populating Tables : Successful Use of the Copy Statement : Error Handling with the Copy Statement : Stop the Copy After a Specified Number of Errors
 
Share this page                  
Stop the Copy After a Specified Number of Errors
To stop the copy after a certain number of errors, specify an error count with the ERROR_COUNT=n clause. For example:
COPY TABLE personnel
    (name = CHAR(0), 
    dept = CHAR(0)nl) 
    FROM 'pers.data'
    WITH ERROR_COUNT = 10;
The default ERROR_COUNT is 1.
This clause is not meaningful when used with the ON_ERROR=CONTINUE clause. See the Error_ Count Option for the COPY statement in the SQL Reference Guide.