EBCDIC CONVERSION

reddy · Post by **reddy** » Tue Mar 21, 2006 6:30 pm

Datastage Gurus,

I am getting fixed width file file from one of our users,in some fields in the last positions i am seeing EBCDIC characters,but i need to convert like the below examples:

a. Billing amount value = 000000200{

Ans:the billing amount is +20.00 dollars.

b. Billing amount value = 000004523C

Ans: the billing amount is +452.33 dollars.

c. Billing amount value = 000023981P

Ans:the billing amount is -2398.17 dollars.

Can you please light on me.

Thanks in advance.
Reddy

s_r_chandru · Post by **s_r_chandru** » Tue Mar 21, 2006 6:41 pm

Hi,

Try to Use the Build In Routine "DataTypePicS9" To convert the data type in EBCDIC into an integer.

-Chandru

rasi · Post by **rasi** » Tue Mar 21, 2006 7:20 pm

Reddy

Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.

eg.

DataTypePicS9(000000200{)/100 = 20.00

Thanks

reddy · Post by **reddy** » Wed Mar 22, 2006 9:19 am

rasi wrote:Reddy

Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.

eg.

DataTypePicS9(000000200{)/100 = 20.00

Thanks

Hi Guys,

Thanks a lot for a quick responses.

I need to get the output with + and _ Signs like this
+20.00 dollars

Thanks in advance
reddy

ArndW · Post by **ArndW** » Wed Mar 22, 2006 9:26 am

Reddy - what is not working the way you would like by using the DataTypePicS9 conversion?

reddy · Post by **reddy** » Wed Mar 22, 2006 9:29 am

ArndW wrote:Reddy - what is not working the way you would like by using the DataTypePicS9 conversion? ...

Hi Guys,

Sorry guys.Everything is working fine.I really appreciate you guys help.

Thanks a lot guys.

Reddy