string to decimal conversion

sunitha_cts · Post by **sunitha_cts** » Thu Oct 22, 2009 5:49 am

Hi,

My table definiton column is varchar ,and coulmn coming from source in the sense extracted from flat files is char ,so i changed the target value from varchar to char.All this is for only a single column issue

but when i tryed to test in a sample job taking the source table definition column as varchar and source field as char and target as varchar. my record are not load into the target dataset.
Could anyone help on this.

Thanks
sunitha

chulett · Post by **chulett** » Thu Oct 22, 2009 6:37 am

You'd have to expand a teensy bit on what "could not load" means before anyone could do anything but guess.

sunitha_cts · Post by **sunitha_cts** » Fri Oct 23, 2009 11:31 pm

Hi,
The values are somewhat like
000000000782911
0000000813736
000000145
00000898545,

coming from source after doing string to decimal and decimal to string conversion ,the values are losing their least sigificant values

consider the value coming after conversion is 14567.87, it is coming as 14567.8 that means the values above 10000.00 we could not be accurate values,basically when we check in DSmanager the column in field def iS varchar and in source it was char and my target value should be varchar again.we cannot modify the source column datatype we are doing this conversion.

Can u help mein resolving this issue.

Thanks
Sunitha

dsusr · Post by **dsusr** » Sat Oct 24, 2009 1:51 am

Where are you viewing the output. If the target is table check the precision and scale for the column in target table.

sunitha_cts · Post by **sunitha_cts** » Sat Oct 24, 2009 8:41 am

Hi,

source is sequential file and target is a dataset.

1) 100023 is the source value
after conversion
Stringto Decimal(DsLink6.VAR1)/100)->10000.2
DecimaltoString(var1,"suppress zero)->10000.2

2)12345 is source value
after conversion
Stringto Decimal(DsLink6.VAR1)/100)->123.4
DecimaltoString(var1,"suppress zero)->123.45
3)6244544 source value
Stringto Decimal(DsLink6.VAR1)/100)->62445.4
DecimaltoString(var1,"suppress zero)->62445.4

THIS IS MY PROBLEM

Thanks
Sunitha

ArndW · Post by **ArndW** » Sat Oct 24, 2009 8:45 am

to reiterate:

dsusr wrote:...check the precision and scale...

(and post your settings as well)

sunitha_cts · Post by **sunitha_cts** » Sat Oct 24, 2009 9:34 am

Hi,

For the column is In the table definitio it is varchar 18
source is char 16
target varchar 18.

Thanks
Sunitha