Char to Deimal Conversion

chrisjones · Post by **chrisjones** » Mon Oct 06, 2008 1:57 pm

Hi ,
I am getting data as Char (6)from source but in the target the cloumn is Decimal(18).

Ex:Source Data
011944
011954
011964
011974.

I am unable to convert the char to Decimal please help me how to convert this data.

John Smith · Post by **John Smith** » Mon Oct 06, 2008 10:04 pm

Have you tried StringtoDecimal function?

vasa_dxx · Post by **vasa_dxx** » Mon Oct 06, 2008 10:11 pm

This is a duplicate thread of :viewtopic.php?p=302816#302816.

Jones,Please delete /unamrk any one of it, hence there won't be any confusion.

Thanks,

chrisjones · Post by **chrisjones** » Tue Oct 07, 2008 10:12 am

Yeah Tried but I am getting all space followed by 5 zeros in Traget.

I execute the same job in my personal laptop in DS 7.5X2 it worked fine..but in my office laptop I am having 7.5.2...because of some reason this StringToDecilam Function Not working....Any idea,why it is not working in DS7.5.2.

Thanks,
Nepal Samala

kumar_s · Post by **kumar_s** » Tue Oct 07, 2008 12:37 pm

What the exact expression that you have used?
Do you get partial padding of zeros and spaces?

chrisjones · Post by **chrisjones** » Tue Oct 07, 2008 4:20 pm

Yeah..Kumar .I am getting from source as Char(6):123456 but when I am trying to load into Target as Dec(18) using StringToDecimal Function it is getting loaded as 0000000000000000.00.

if I change the datatype as Dec(6) the data is loading as space12345.

The last digit 6 is getting trunacting.Please let me know if u have any idea

Thanks,
Chris Jones

kumar_s wrote:What the exact expression that you have used?
Do you get partial padding of zeros and spaces? ...

vasa_dxx · Post by **vasa_dxx** » Tue Oct 07, 2008 9:51 pm

chrisjones wrote:Yeah..Kumar .I am getting from source as Char(6):123456 but when I am trying to load into Target as Dec(18) using StringToDecimal Function it is getting loaded as 0000000000000000.00.

if I change the datatype as Dec(6) the data is loading as space12345.

The last digit 6 is getting trunacting.Please let me know if u have any idea

Thanks,
Chris Jones

kumar_s wrote:What the exact expression that you have used?
Do you get partial padding of zeros and spaces? ...

Check for setting max datasize limit in dsadm. There you can specify if Data is to be truncated for oever the limit.

chrisjones · Post by **chrisjones** » Wed Oct 08, 2008 2:54 pm

Hi ,
Where can I see in dsadmin ,can you tell exactly where to look in dsadmin.

In my personal PC i can see Maximum Decimal Size:18 under Mainframe tab but in my office I could see this option since Mainframe tab is disabled... so you are refering the same Maximum Decimal Size under Mainframe Tab or r u refering some other .Please let me know.

Cheers,
Chris.

vasa_dxx wrote:
chrisjones wrote:Yeah..Kumar .I am getting from source as Char(6):123456 but when I am trying to load into Target as Dec(18) using StringToDecimal Function it is getting loaded as 0000000000000000.00.

if I change the datatype as Dec(6) the data is loading as space12345.

The last digit 6 is getting trunacting.Please let me know if u have any idea

Thanks,
Chris Jones

kumar_s wrote:What the exact expression that you have used?
Do you get partial padding of zeros and spaces? ...
Check for setting max datasize limit in dsadm. There you can specify if Data is to be truncated for oever the limit.

DSXchange