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
Decimal to Character
Moderators: chulett, rschirm, roy
Re: Decimal to Character
Inputcolumn[1,4] should work.............
Re: Decimal to Character
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".
"Insufficient result space for explicit conversion of NUMERIC value '128119000.00' to a CHAR field".
Decimal to character
Hi,
you can use "decimalTo String function" in transformer stage .
Hope it will help you.
thanks
fareeda
you can use "decimalTo String function" in transformer stage .
Hope it will help you.
thanks
fareeda
Thanks
Decimal to character
Hi,
you can use "decimalTo String function" in transformer stage .
Hope it will help you.
thanks
fareeda
you can use "decimalTo String function" in transformer stage .
Hope it will help you.
thanks
fareeda
Thanks