BCP utility in Sybase(Unix Environment)

zmycoco2

于 2013-05-28 13:11:12 发布

阅读量940

点赞数

CC 4.0 BY-SA版权

分类专栏： Sybase Unix Shell

本文链接：https://blog.youkuaiyun.com/michaelzhou224/article/details/8984200

Unix Shell 同时被 2 个专栏收录

19 篇文章

订阅专栏

Sybase

4 篇文章

订阅专栏

本文介绍如何使用Sybase的bcp工具将数据库表导出到.dat文件中，并提供了具体的命令示例。同时，文章解释了如何指定自定义接口文件及如何设置导出过程中的各种参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

We can use below command for bcp out a table to *.dat file,

$SYB_BIN/bcp hnwreport.dbo.TblHNWCustomer out ${SYB_DATA}/${TABLE}.prod.dat -I/opt/muni/HNWEnv/HNW_interfaces.txt -U hnwuser -P Lip0v123 -S STEP_PROD_NY_DS –t’|’ -b 10000 -e${ERRFILE} -T –c

Please be vigilant that if you want to use self-defined interface file rather than default system interface, you have to use –I option and define interface file in place.

If you want to use bcp utility, you can export Sybase,

export SYBASE=/optware/aseclient1503x/ase155b/

$SYBASE/OCS-15_0/bin/bcp hnwreport.dbo.TblHNWCustomer out /opt/HNW/HNWFileAnalysis/HNWOutput/TEST.dat -I/opt/muni/HNWEnv/HNW_interfaces.txt -U hnwuser -P Lip0v123 -S STEP_PROD_NY_DS -t'|' -b 10000 -e${ERRFILE} -T –c

$SYBASE/OCS-15_0/bin/isql -I/opt/muni/HNWEnv/HNW_interfaces.txt -U hnwuser -P Lip0v123 -S STEP_PROD_NY_DS < /tmp/test.sql