Copy Data to Partitions Using bcp

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, or a single file for each partition.

If you do not specify a destination file name, the SAP ASE server creates file names based on the partition names.

These examples show how to copy of data from bigtable, which is partitioned three ways—ptn1, ptn2, and ptn3—to various operating system files:

Related reference