| Author |
Message
|
| n1ghtrain |
 Posted: Thu Nov 08, 2007 11:03 pm Post subject: Precision of Decimal in CWF |
 |
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
I am facing a problem in modeling a decimal field
Source field : 123.456
Target expected : +00123.456
I have modeled the target field as decimal (CWF)
Physical Type : External Decimal
length count : 10
Length Units : Bytes
Signed :Yes
Sign Orientation : Leading Separate
Virtual Decimal Point : 0
String Justification : Right Justify
Padding Character : '0'
Output : +000000123
Fractional part is getting truncated. (If i give Virtual decimal point as 3, i can see the value as +000123456)
Help..!! |
|
| Back to top |
|
 |
| n1ghtrain |
| Posted: Thu Nov 08, 2007 11:24 pm Post subject: |
|
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
I have also tried to model it in TDS.
Sign Orientation : Leading
Postive : +
Negative : -
This works as expected for negatives but for postives the '+' won't appear |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Nov 09, 2007 1:01 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi n1ghtrain,
I remember doing some decimal 'trial and error' some weeks back and found similar 'Virtual Decimal Point' problems, thats when I found 'simple restriction' (under types) and it helped me achieve length of decimal with restriction on number of fractions...
I'm not saying this has to be the way to go, but you could try combos of both, might just work for your requirement...
Regards. |
|
| Back to top |
|
|
| n1ghtrain |
| Posted: Fri Nov 09, 2007 3:40 am Post subject: |
|
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
Tried that .. No Luck ..  |
|
| Back to top |
|
|
| n1ghtrain |
| Posted: Sun Nov 11, 2007 7:50 pm Post subject: |
|
|
Apprentice
Joined: 23 Mar 2006
Posts: 48
Location: Bangalore
|
Hi All,
Still stuck with this..
(Only solution i could think of is to model this field as string and convert the decimal to the format i require.)
Any thoughts/Suggestions.? |
|
| Back to top |
|
|
| Mensch |
| Posted: Mon Nov 12, 2007 2:04 am Post subject: |
|
|
Disciple
Joined: 17 Jul 2005
Posts: 166
|
Hi n1ghtrain,
I did the same thing when I was running out of time.... 
_________________
Thanks and Regards ,
Mensch |
|
| Back to top |
|
|
|
|
