5. Populating Tables : Successful Use of the Copy Statement : Error Handling with the Copy Statement : Continue the Copy and Log Errors
 
Share this page                  
Continue the Copy and Log Errors
By using both LOG and ON_ERROR = CONTINUE in the clause, put invalid rows in a log file and continue to process valid ones. Correct the rows in the log file and load them into the database. For example:
copy table personnel 
    (name = char(0), 
    salary = char(0)nl)
    from 'pers.data'
    with on_error = continue,
    log = 'badrows.data';