CFF stage not reading the special character correctly

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gowrishankar_h
Participant
Posts: 42
Joined: Wed Dec 26, 2012 1:13 pm

CFF stage not reading the special character correctly

Post by gowrishankar_h »

Hi,


We are reading binary file with fixed width in Complex flat file stage.
For a particular field which is defined as character datatype we will get values from input like below

Russia!
London!

but when we view the data through CFF the values is showing like below

Russia]
London]

Can you please let us know do i miss any config or anything have to be done before reading it?

Thanks in advance
rohithmuthyala
Participant
Posts: 57
Joined: Wed Oct 21, 2009 4:46 am
Location: India

Post by rohithmuthyala »

Hi All,

Even I'm getting the same problem, my source is MF Binary file, when trying to read the value for a column which is of character type in CFF stage with below properties Character set = EBCDIC.

The values in MF is given as
China!
Japan!

The same value when coming out of CFF is
China]
Japan]

Can anyone help who faced similar issue and resolved it.

Thanks..
kethya11
Participant
Posts: 7
Joined: Mon Feb 17, 2014 2:55 am

CFF Stage

Post by kethya11 »

I am able to saw the special character (!) when property set to: Character set = EBCDIC

I am give 2 records got the data with special character values
gowrishankar_h
Participant
Posts: 42
Joined: Wed Dec 26, 2012 1:13 pm

Re: CFF Stage

Post by gowrishankar_h »

Thanks,

Can i please know what value you have given for the APT_EBCDIC_VERSION?
Post Reply