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
For more information, see “bcp Modes”.
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 Adaptive Server 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.
