BCP一般存放在所安裝的ASE或者Open Client 的BIN目錄中版本以前的ASEbcp存放目錄為 $SYBASE/bin版本(含版本)以後存放目錄為 $SYBASE/OCS_x/bin其中$SYBASE為SYBASE安裝目錄_x代表版本顯示為_或者_可執行文件名稱為bcpEXE
參數列表如下(可用 bcp – 得到)
usage: bcp [[database_name]owner]table_name[:slice_number] {in | out} datafile
[m maxerrors] [f formatfile] [e errfile]
[F firstrow] [L lastrow] [b batchsize]
[n] [c] [t field_terminator] [r row_terminator]
[U username] [P password] [I interfaces_file] [S server]
[a display_charset] [q datafile_charset] [z language] [v]
[A packet size] [J client character set]
[T text or image size] [E] [g id_start_value] [N] [X]
[M LabelName LabelValue] [labeled]
[K keytab_file] [R remote_server_principal]
[V [security_options]] [Z security_mechanism] [Q]
常用數據備份格式為
[] [] []
From:http://tw.wingwit.com/Article/program/Sybase/201311/21917.html