5. Populating Tables : Successful Use of the Copy Statement : Error Handling with the Copy Statement : Stop or Continue the Copy
 
Share this page                  
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.