Use bcp to copy data from a table to an operating system file. Specify a table name and one or more partitions as the source.
You can copy data:
To a single file for all partitions
To a single file for each partition
If you do not specify a destination file name, Adaptive Server creates file names based on the partition names.