Issue in reading data with CFF stage for binary file

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
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Issue in reading data with CFF stage for binary file

Post by parag.s.27 »

After reading many posts we still could not find the solution hence posting it here.

We are trying to read a mainframe file using CFF stage. In the input binary file we are receiving "!" sign as part of FIRST_NAME column as per the mainframe system DB2 table.

When we are reading this file in DataStage using CFF the NLS is Default (UTF-8), encoding is Big-endian and the file type is Binary with data as EBCDIC. When we see the output, the "!" character is getting converted into "]" and causing duplicate client profile creation. We tried all sorts of NLS settings such as ASL-ASCII, ISO8859-1 and so on. Also tried different encodings such as native-endian, little-endian etc. Nothing seems to be working.

The issue is more suspicious because if we try to read this file in DataStage 7.5 using CFF stage then it is correctly reading the data with "!". All the settings in CFF stage between DS7.5 Vs DS8.1 are same still why the difference in reading values.
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Post Reply