BCP pour une colonne de type univarchar
Bonjour,
J'ai une table avec deux colonnes de type univarchar
Apres le bcp out
Citation:
[maarvbdd](mahe)/home/mahe/tools #bcp dicobase..CONFIGURATION out alain.dat -S RASEAFFACT -U sa -P $SA_PWD -n
Starting copy...
851 rows copied.
Clock Time (ms.): total = 12 Avg = 0 (70916.67 rows per sec.)
je lance
Code:
bcp dicobase..CONFIGURATION in alain.dat -S RASEARCHIVE -U sa -P sa2rarch -n
Les deux colonnes sont tronquer sur le premier caractère
Citation:
...
CSLIB Message: - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow.
CSLIB Message: - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow.
CSLIB Message: - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow.
CSLIB Message: - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow.
...
La source:
NUM_CONFIG CODE_TYPE_CONFIG NOM_CONFIG DESCRIPTION_CONFIG DT_CREAT UTIL_CREAT DT_MODIF UTIL_MODIF CODE_SOCIETE CODE_ETABLISSEMENT CODE_NIVEAU_CONFIG MODELE
------------- ------------------- ------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------ ------------------- -------------------- ------------------- -------------------- --------------- --------------------- --------------------- ---------
00000463 1 SOUTENU STANDARD - DAILLY - AVANT ECHEANCE - 00492080 SOUTENU STANDARD - DAILLY - AVANT ECHEANCE - 00492080 21/08/2012 09:38:03 LASCALA 21/08/2012 09:38:03 LASCALA S027 E001 (null) 0
00000464 2 SOUTENU STANDARD - DAILLY - APRES ECHEANCE - 00492080 SOUTENU STANDARD - DAILLY - APRES ECHEANCE - 00492080 21/08/2012 09:38:03 LASCALA 21/08/2012 09:38:03 LASCALA S027 E001 (null) 0
La cible
NUM_CONFIG CODE_TYPE_CONFIG NOM_CONFIG DESCRIPTION_CONFIG DT_CREAT UTIL_CREAT DT_MODIF UTIL_MODIF CODE_SOCIETE CODE_ETABLISSEMENT CODE_NIVEAU_CONFIG MODELE
------------- ------------------- ------------- --------------------- ------------------- -------------------- ------------------- -------------------- --------------- --------------------- --------------------- ---------
00000463 1 S S 21/08/2012 09:38:03 LASCALA 21/08/2012 09:38:03 LASCALA S027 E001 (null) 0
00000464 2 S S 21/08/2012 09:38:03 LASCALA 21/08/2012 09:38:03 LASCALA S027 E001 (null) 0
