The string contains an untranslatable character
Posted: Mon May 23, 2011 12:32 am
Hi,
I am getting the below error
TDC_EPRS_GPC_CLAS_E,0: RDBMS code 6706: The string contains an untranslatable character.
SQL statement:
USING (LD_SEQ_I INTEGER, EFF_D DATE, NVLD_REC_C CHAR(3), LD_BTCH_I INTEGER, FD_BTCH_I INTEGER, GPC_CLAS_I INTEGER, GPC_CLAS_N VARCHAR(300), SEG_SRC_I INTEGER, FMLY_SRC_I INTEGER, CLAS_SRC_I INTEGER, GPC_CLAS_STAT_C CHAR(12), REQ_DEL_D DATE, RDY_TO_PURG_F CHAR(3), CRTE_USER_I CHAR(48), CRTE_TS TIMESTAMP(6), UPDT_USER_I CHAR(48), UPDT_TS TIMESTAMP(6))
INSERT INTO EPRS_GPC_CLAS_E(LD_SEQ_I,EFF_D,NVLD_REC_C,LD_BTCH_I,FD_BTCH_I,GPC_CLAS_I,GPC_CLAS_N,SEG_SRC_I,FMLY_SRC_I,CLAS_SRC_I,GPC_CLAS_STAT_C,REQ_DEL_D,RDY_TO_PURG_F,CRTE_USER_I,CRTE_TS,UPDT_USER_I,UPDT_TS) VALUES(:LD_SEQ_I,:EFF_D,:NVLD_REC_C,:LD_BTCH_I,:FD_BTCH_I,:GPC_CLAS_I,:GPC_CLAS_N,:SEG_SRC_I,:FMLY_SRC_I,:CLAS_SRC_I,:GPC_CLAS_STAT_C,:REQ_DEL_D,:RDY_TO_PURG_F,:CRTE_USER_I,CAST(:CRTE_TS AS TIMESTAMP(6)),:UPDT_USER_I,CAST(:UPDT_TS AS TIMESTAMP(6)))
(CC_TeraDBStatement::dbsExecute, file CC_TeraDBStatement.cpp, line 1,325)
Using DataStage 8.5, parallel job, on Windows OS.
DB2 Stage --> Transformer --> Teradata Stage
Metadata match perfectly with source and target.
I am getting the below error
TDC_EPRS_GPC_CLAS_E,0: RDBMS code 6706: The string contains an untranslatable character.
SQL statement:
USING (LD_SEQ_I INTEGER, EFF_D DATE, NVLD_REC_C CHAR(3), LD_BTCH_I INTEGER, FD_BTCH_I INTEGER, GPC_CLAS_I INTEGER, GPC_CLAS_N VARCHAR(300), SEG_SRC_I INTEGER, FMLY_SRC_I INTEGER, CLAS_SRC_I INTEGER, GPC_CLAS_STAT_C CHAR(12), REQ_DEL_D DATE, RDY_TO_PURG_F CHAR(3), CRTE_USER_I CHAR(48), CRTE_TS TIMESTAMP(6), UPDT_USER_I CHAR(48), UPDT_TS TIMESTAMP(6))
INSERT INTO EPRS_GPC_CLAS_E(LD_SEQ_I,EFF_D,NVLD_REC_C,LD_BTCH_I,FD_BTCH_I,GPC_CLAS_I,GPC_CLAS_N,SEG_SRC_I,FMLY_SRC_I,CLAS_SRC_I,GPC_CLAS_STAT_C,REQ_DEL_D,RDY_TO_PURG_F,CRTE_USER_I,CRTE_TS,UPDT_USER_I,UPDT_TS) VALUES(:LD_SEQ_I,:EFF_D,:NVLD_REC_C,:LD_BTCH_I,:FD_BTCH_I,:GPC_CLAS_I,:GPC_CLAS_N,:SEG_SRC_I,:FMLY_SRC_I,:CLAS_SRC_I,:GPC_CLAS_STAT_C,:REQ_DEL_D,:RDY_TO_PURG_F,:CRTE_USER_I,CAST(:CRTE_TS AS TIMESTAMP(6)),:UPDT_USER_I,CAST(:UPDT_TS AS TIMESTAMP(6)))
(CC_TeraDBStatement::dbsExecute, file CC_TeraDBStatement.cpp, line 1,325)
Using DataStage 8.5, parallel job, on Windows OS.
DB2 Stage --> Transformer --> Teradata Stage
Metadata match perfectly with source and target.
