bcp requirements

Before using bcp, you need to provide it with basic data information and prepare both the data for transfer and the command to access the data.

Basic requirements

You must supply the following information to transfer data successfully to and from Adaptive Server:

You can also use bcp to modify the storage type, storage length, and terminator for each column if you want to do so.

Permissions

You must have an Adaptive Server account and the appropriate permissions on the database tables or views, as well as the operating system files to use in the transfer to use bcp.

Pre-transfer tasks

Before you can use bcp in, you must prepare the command and the data for transfer:

In addition: