Bonjour,

J'ai une table avec deux colonnes de type univarchar

Apres le bcp out
[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 : Sélectionner tout - Visualiser dans une fenêtre à part
bcp dicobase..CONFIGURATION in alain.dat -S RASEARCHIVE -U sa -P sa2rarch -n
Les deux colonnes sont tronquer sur le premier caractère
...
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
Merci d'avance