problems in reading an ebcdic file thorugh sequential stage

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Aug 26, 2009 7:23 pm

I am trying to read a file which was transfered from mainframes machine to the datastage sever in.txt format.The file is in ebcdic format,though I am able to read majority of the columns properly some of the columns data are not displayed properly.In the format tab this is what I have set
DataFormat=Binary
Characterset=Ascii
Record delimiter=Unix new line
Delimiter=none
Allow all zeros=yes

Do I need to set any other properties to read the data properly.

Is there any other way that file can be read easily like convert the file first into ascii on DataStage server and then reuse it in DataStage.

chulett · Post by **chulett** » Wed Aug 26, 2009 10:26 pm

If the file is in "ebcdic format" why have you set Characterset=Ascii? It means what it is not what you want it to be.

RAJEEV KATTA · Post by **RAJEEV KATTA** » Thu Aug 27, 2009 12:05 pm

There is a program which is transfering the file I think its transfering it in ascii character set format because when I try to load the TD it changes the properties by default to stated as below.

chulett · Post by **chulett** » Thu Aug 27, 2009 12:10 pm

OK, that's fine. HOWEVER if you have any packed fields then a simple ASCII conversion will destroy them. Are they the fields that are not 'displaying properly'?