You are not logged in.
I am trying to load one EBCDIC file.It contains one column which is defined as zoned decimal value.
in one row it contains Packed decimal value.So while loading this file we got following error.
We try to set default value but have not work.
Can anyone help me out in this issue ?
Welcome to Talend Community!
Your exception is on the column CASEUPCPCP. Because apparently it is still defined as numeric (Picture) but the data is "....". Try changing your xcj2 file. The types are set to 9 in there.
Thanks for your reply .. But if we make change in xc2j file for that field it may affect other records .Because that error is giving only for single record from the source file.other records are loading correctly.
I am also facing same issue i.e one column containing normal data like (122 , 123 and so on)
and in the same column i have packed decimal data.
(1) If i give normal data type i.e 9 in COBOL layout it will load correctly until normal data (122 , 123 and so on) and troughs an error while getting Packed decimal data.
(2) If i give packed decimal data type i.e 9 COMP-3 in COBOL it is giving error in first row itself since it is having normal data.
Please help me.