Decimal to Character

[monaz]

Hi my requirment is to convert decimal to character by Truncating decimal.How to implement this..

For Example
Input is Decimal(17,4)
as 128119000.000


OUTPUT should be Char(4)
1281


Can i do it in Sybase database itself or Datastage.
Please advice me on this... ASAP

[sachin1]

Inputcolumn[1,4] should work.............

[monaz]

is it not necessary to convert decimal to character...I tried working with CONVERT function but i am getng the below warring.
"Insufficient result space for explicit conversion of NUMERIC value '128119000.00' to a CHAR field".

[DSguru2B]

You do not need to apply any functions for type convertions. Its seamless in server edition, as beneath the covers, everything is a char.

[monaz]

Thanks it has been worked out...

[fareeda_b]

Hi,

you can use "decimalTo String function" in transformer stage .


Hope it will help you.


thanks
fareeda

[fareeda_b]

Hi,

you can use "decimalTo String function" in transformer stage .


Hope it will help you.


thanks
fareeda

[chulett]

It won't because a) they resolved this several months ago and b) there's no such function in the Server edition.