EBCDIC

sriec12 · Post by **sriec12** » Tue Apr 26, 2011 11:08 pm

Hi guys,

my mapping looks like

seq===>txn====>oracle

1) well my data is in EBCDIC format. There is one field called s_code its data type is char(1). When i load in to target , i am getting  (this format in the field).

2) so in sql developer i wrote a query

select ascii(s_code) from orc_stg. I got values like 10,60,65 and so on.

My question is: I need to set property of s-code field in sequential file. so that my staging should load values like 10,60,65 and so on. I dont need values like .

Please help in setting properties at sequential file.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 27, 2011 12:05 am

From the Available options to add field choose the "read as EBCDIC" property. (I'm not certain of this property name and am not in a position to check at the moment.)

sriec12 · Post by **sriec12** » Wed Apr 27, 2011 5:15 am

well in sequential file i use charchter set as EBCDIC.

Can any one telll me?

is it possible to use ascii funtion in transformer?

if i can use like dis ascii(s_code) i can get result ?

FranklinE · Post by **FranklinE** » Wed Apr 27, 2011 10:01 am

There are some details you haven't given us -- not complaining, just mentioning -- that might help decide on the right answer.

I have had no problems letting DataStage handle character sets. I read EBCDIC and write ASCII without any explicit conversions in between.

1) The data type doesn't tell me what the valid values are. Do you expect to see only alphanumeric characters, or are other values valid? Also, when you see something like "", that is your browser/editor's decision on how to display the character. How the data is displayed is not relevant to its value in storage.

Verify the EBCDIC code value of the character first, then verify that DS is converting it to the correct ASCII code value. If the conversion is correct, then you have a display problem and not a conversion problem.