Sybase - Sybase BCP (bulk copy program)

Out syntax -> export data

 

 

Queryout syntax -> export data

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

 

-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

 

-E -> handle identity column

 

 

 

 

 

 

-U -P -> database login account setup

-U database login user name
-P database login password

 

-S -> datasource name

 

 

 

-Jutf8 (Sybase ONLY ?)

 

 

Use .csv file to do bcp

 

 

 

Bcp problem