EBCDIC
Posted: 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.
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.