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:

Copies the data in bigtable to file1:
```
bcp mydb..bigtable out file1
```

Copies the data from ptn1, ptn2, and ptn3 to file2:

bcp mydb..bigtable partition ptn1, ptn2, ptn3 out file2

Copies the data from ptn1 and ptn2 to data files ptn1.dat and ptn2.dat:
```
bcp mydb..bigtable partition ptn1, ptn2 out ptn1.dat,
ptn2.dat
```
Copies the data from ptn1 and ptn2 to ptn1.dat and ptn2.dat:
```
bcp mydb..bigtable partition ptn1, ptn2 out
```