• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Error in loading EBCDIC File

#1 2012-06-15 14:30:35

nshete01
New member
Registered: 2011-09-30
Posts: 9

Error in loading EBCDIC File

Tags: [error]

Hi..
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 ?


Uploaded Images

Offline

#2 2012-06-18 05:07:45

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Error in loading EBCDIC File

Hi

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.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-06-18 06:16:25

nshete01
New member
Registered: 2011-09-30
Posts: 9

Re: Error in loading EBCDIC File

Hi Pedro,
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.

Offline

#4 2012-06-25 06:05:46

nshete01
New member
Registered: 2011-09-30
Posts: 9

Re: Error in loading EBCDIC File

Can anyone tell me how to deal with this kind of error..It is still not solved?

Offline

#5 2012-06-25 09:16:08

raghu12345
Member
Registered: 2011-05-20
Posts: 52

Re: Error in loading EBCDIC File

Hi,

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.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Error in loading EBCDIC File

Board footer

Powered by FluxBB