Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Urgent: Need to Convert a CURR field to Zoned decimals.

Former Member

‎04-18-2006 11:33 AM

0 Kudos

Hi All,

I have a requirement to convert a Field of type CURR(15,2) to Zeros filled Zoned Decimal.

Please let me know how to do it.

Thanks in advance

3 REPLIES 3

nishanthbhandar
Contributor

‎04-18-2006 12:35 PM

0 Kudos

Will you please provide more detials on what you need to achieve through the Zoned Decimals .. i.e a better explanation of what you need would be more helpful for anyone to post a resolution ..

Former Member

‎04-18-2006 12:59 PM

0 Kudos

Hi Nishant,

I will get amount from a FM, the Amount is of type CURR(15,2). I have to convert this CURR field into a Zero filled Zoned decimals. I will pass this Zoned Decimal value to a outbound flat file.

Please let me know if i am not clear.

Regards

Nanda

nishanthbhandar
Contributor
In response to Former Member

‎04-18-2006 1:19 PM

0 Kudos

Nanda,

What i wanted to know is the output that you expect.

Suppose the value from the FM(i.e) CURR(15,2) is suppose say 9.23 what is the expected format that you want in the output file .. ? What exactly do you mean by zoned decimals . .?

Cheers

Nishanth