Sybase - Sybase BCP (bulk copy program)

阅读目录(Content)

• Out syntax -> export data
• Queryout syntax -> export data
• -Y -> enable conversion (Sybase ONLY)
• -E -> handle identity column
• -U -P -> database login account setup
• -S -> datasource name
• -Jutf8 (Sybase ONLY ?)
• Use .csv file to do bcp
• Bcp problem

回到顶部(go to top)

Out syntax -> export data

 

 

回到顶部(go to top)

Queryout syntax -> export data

In sybase bcp, no such syntax.
Please use a view alternatively and then fetch view instead.

 

回到顶部(go to top)

-Y -> enable conversion (Sybase ONLY)

Issue log:

Starting copy...
Server Message: LN_SA_GMCRD_DEV1 - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.

Solution:
bcp UnityCredit.dbo.t_FlashDataTest in C:\temp\falsh_data.bcp -c -S ln_sa_gmcrd_dev1 -Y -U UnityCredit_dbo -P Nomura99

Attention: -Y is only available for Sybase bcp tool

 

回到顶部(go to top)

-E -> handle identity column

 

 

 

 

 

 

回到顶部(go to top)

-U -P -> database login account setup

-U database login user name
-P database login password

 

回到顶部(go to top)

-S -> datasource name

 

 

 

回到顶部(go to top)

-Jutf8 (Sybase ONLY ?)

 

 

回到顶部(go to top)

Use .csv file to do bcp

 

 

 

回到顶部(go to top)

Bcp problem