DecimalToDecimal Syntax

[gagan8877]

Hi

I am have a varchar(50) field:

Source Value Example: 00000000000100000. (it has a decimal at the end wihout any digits after the decimal)

Needed value at traget: 100000.00

Source and target both need to be varchar(50) data type.

I tried to do the folowing:

Trim(DecimalToString(DecimalToDecimal(StringToDecimal(Trim(To_Create_Objs.Value_D)),2)), "0","L")

1. Trim spaces
2. Convert String to Decimal - this gives 0000000000000000000000100000.0000000000
3. Convert Decimal to Decimal to retain Scale of 2 (places after the decimal) - this fails
4. Convert Decimal back to String for triming zeros and for business requirements
5. Trim leading zeros from string

I tried this syntax of DecimalToDecimal Based on the folloing:

viewtopic.php?t=103441&highlight=decimaltodecimal

But it fails with

APT_CombinedOperatorController(2),0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "2" for conversion "decimal=decimal_from_decimal(decimal)": Unexpected input "2" found at beginning of conversion args.
Operator signalled one or more errors.

I do not have the orchestrate manual and Parallel Dev Guide 7.5 does not have complete syntax or an example for DecimalToDecimal, it only lists the arguments, so if someone can guide me, I will be thankful.

Thanks

[DSguru2B]

It is because your trying to fit a decimal number into a varchar field. It will not work. You need to do StringToDecimal() to fix the lenth and precision and then use DecimalToString() to convert it back to varchar.

[gagan8877]

Can u specify scale in StringToDecimal()? If yes, can u please tell me the complete syntax?

Thanks

It is because your trying to fit a decimal number into a varchar field. It will not work. You need to do StringToDecimal() to fix the lenth and precision and then use DecimalToString() to convert it back to varchar.

[DSguru2B]

Precision is the length of the field and scale is the numbers after the decimal. For exact syntax, check DS help for "Parallel Job Functions" or search here.

[gagan8877]

Dear Mr. Guru To Be

I respectfully would like to state that I am no guru but I do know what is scale :D The statement decimal (p, s) with p as precision and s as scale represents a decimal number with up to p digits and s of them will be on the right of the decimal point. I already stated above that I did not find much in the Parallel Job Dev Guide and thats why I posted it here after searching for "DecimalToDecimal". So if u can help me with the syntax of the stmt without going into Decimal Precision and Scale that would be awesome.

Scale is the length of the field and prcision is the numbers after the decimal. For exact syntax, check DS help for "Parallel Job Functions" or search here.

Scale is the length of the field and prcision is the numbers after the decimal. For exact syntax, check DS help for "Parallel Job Functions" or search here.

[DSguru2B]

Can you have input coming in with a valid scale (00010002.2) ?

[gagan8877]

So what should be the valid argument in the DecimalToDecimal function?
Thanks

Can you have input coming in with a valid scale (00010002.2) ?