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
