DSXchange

I have tried the same routine on a differrent server hosting 7.5, but I am getting same results....
Can anyone explain what could be wrong ??

Mine is DataStage 7.5.1A

robvonk wrote:I get these results.

It seems that my results are as expected.

We're using Datastage server 7.5.1 on windows. Maybe there's a bug in your version?

I wish I had your machine
Hey is it possible for you to share the Hardware, Operating System and DataStage version details please...

I tried the 'Ans = SSUB(1234567890.12,1234567890.2)' code in a routine and it gives back 0.08 correctly. Are you trying to put it into an integer? The results are confusing... My test routine is: Ans = Arg1-Arg2:' ':SSUB(Arg1,Arg2):' ':SDIV(SSUB(SDIV(Arg1,1,2),SDIV(Arg2,1,2)),1,2):' ':TRIM(Arg1,' '...

Hi, I am using String Maths for arithmetic operations on bigger numbers, but I am facing a problem with SSUB: Example: SSUB(1234567890.12,1234567890.2) is resulting in 0 instead of -0.08 i,e SSUB is returning a 0 when the difference is less than -0.1 Getting this difference calculation right, is var...

ok.. I ll test these functions.. thanks

Hi, I am facing the same problem today.. but I do not understand the soultion and the problem. In my case, the output file is being created in EBCDIC and the column was initially defined as Decimal data type and default padding charatcer as #. Now after changing it to NVarChar , it started givign th...

Check your NLS settings.... DataStage, if unable to translate a character, converts to '?'

the second argument specifies the PRECISION and the third argument specifies whether rounding has to happen or truncation. In my case I need to round off to the second decimal position, but in case the number is big enough, eg. Input AMT = 12345678901234567890123.123 RATE_MULT = 1.25500001 RATE_DIV ...

Hi, Initially my problem was with arithmetic operations of number with larger singinifcant number of digits, but this was solved by using string mathematics functions. But now, I also need to use FIX function to round of to 2 digits. eg. Original Function: FIX(Input.FOREIGN_AMOUNT*(Input.RATE_MULT/I...

Thanks Chulett !!

The job is getting compliled without any warnings.. So now I am proceeding with using SDIV etc
Is it not possible to add the function to DSParams ??

Has any one faced such requirement ?

Hi, I am facing problems with Decimal numbers arithmetic operations, esp for (23,3) format decimal numbers. The forum search results guide me to the usage of String Math functions, like, SDIV and SMUL etc. I tested them using a routine and the results are correct. But I am unable to use these functi...

I would try for handling this requirement in some other way... shall get back once some solution is there...

Install the packaged tutorial... its very good for beginning with DataStage server edition.

use the search facility of th forum... its good
Check this post