Home

	Expand Search

Utility Guide

Chapter 3 Using bcp to Transfer Data to and from Adaptive Server

Copy out and error files

Copy out and error files

During the copy out process, as with copy in, bcp overwrites any file of the same name and does not create an error file if no errors occurred.

There are two situations that cause rows to be logged in the error file during a copy out:

• A data conversion error in one of the row's columns

• An I/O error in writing to the host file

Keep the following in mind when working with error files generated by copy out:

• bcp logs rows in the error file in the default character format.

• All data values print as characters with tabs between the columns and a newline terminator at the end of each row.