Chapter 4: Using bcp to Transfer Data to and from Adaptive Server

Versions earlier than 15.0.3 did not allow you to run fast bcp on tables with non-clustered indexes or triggers. Cluster Edition version 15.0.3 and later removes this restriction.

This chapter explains how to use the bulk copy utility, bcp, to move data between Adaptive Server and an operating system file.

bcp provides a convenient, high-speed method for transferring data between a database table or view and an operating system file. bcp can read or write files in a wide variety of formats. When copying in from a file, bcp inserts data into an existing database table; when copying out to a file, bcp overwrites any previous contents of the file.

For a detailed description of bcp syntax, see bcp.