Before You Transfer

Prepare the command and the data for transfer before using bcp in.

To use either fast or fast-logged bcp, set select into/bulkcopy/pllsort to true. For example, to turn on this option for the pubs2 database, enter:

sp_dboption pubs2, "select into/bulkcopy/pllsort", true

To use fast bcp, remove indexes on the target table.

In addition:

If you are running Open Client version 11.1 or later and are using an external Sybase configuration file, enable bcp by adding:
```
[BCP]
```
Set the $SYBASE environment variable to the location of the current version of SAP ASE before using bcp.
To use a previous version of bcp, set the CS_BEHAVIOR property in the [bcp] section of the ocs.cfg file:
```
[bcp]
CS_BEHAVIOR = CS_BEHAVIOR_100
```
If you do not set CS_BEHAVIOR to CS_BEHAVIOR_100, use functionality for bcp 11.1 and later.