Currently, the bcp option -e errorfile logs the rows rejected due to conversion or format errors into an error file. ESD #8 extends the functionality of this option to log all rejected rows including those resulting from inserting duplicate rows when unique constraint is present, inserting into a table-partition that doesn’t fit the partition criteria, and truncation of data.
Sybase recommends that you use the -e errorfile option in conjunction with -d discardfileprefix to help identify and diagnose the problem rows logged in the discard file.
If -e errorfile is
specified, the error messages appear on your terminal and are also
logged in the error file.
