- 论坛徽章:
- 0
|
我第一次做BCP,dbname T_JXC_ZJ,tablename SPFL,server ZHANGJ,系统是WIN2000,sybase 11.92。
我是这样做的:(没有加-c,-c是什么意思啊?)
D:\>;bcp T_JXC_ZJ..SPFL out D:\DATA\SPFL.TXT -S ZHANGJ -U sa -P
但是显示结果:
Enter the file storage type of field SPFL [char]:char
Enter prefix-length of field SPFL [0]:0
Enter length of field SPFL [12]: 12
Enter field terminator [none]: none
Enter the file storage type of field NAME [char]: char
Enter prefix-length of field NAME [0]: 0
Enter length of field NAME [30]: 30
Enter field terminator [none]: none
Enter the file storage type of field JJL [float]: float
Enter prefix-length of field JJL [1]: 1
Enter field terminator [none]: none
Enter the file storage type of field KCTS [smallint]: smallint
Enter prefix-length of field KCTS [1]: 1
Enter field terminator [none]: none
Do you want to save this format information in a file? [Y/n] n
Starting copy...
Server Message: - Msg 2403, Level 10, State 0:
WARNING! Some character(s) could not be converted into client'
Unconverted bytes were changed to question marks ('?').
426 rows copied.
Clock Time (ms.): total = 1 Avg = 0 (426000.00 rows per sec.)
哪位高手能帮给我说明说明,解释解释。谢谢拉! |
|