Issue with ABS and MOD Function in Parallel Extender Job

[ShaneMuir]

Modulus returns the remainder which is not mere subtraction.

I realise this, but looking back to the original posts requirements, it would appear all that is required is a substraction. Why go to all the trouble of MOD?

Unless of course the figures given in the original post were coincidentally giving the same result with a subtraction.

[pratheeksha]

We can define MOD function as

MOD(m,n)= m-n*floor(m/n)

As we have Floor function available in datastage, this calculation could be done in a stage variable and the final value could be used.

[ray.wurlod]

Mod() is, of course, an INTEGER division function, as noted by Arnd and others.

Another solution would be to increase the arguments by powers of ten until they were integer-equivalents, then reduce back afterwards.

But why re-open this thread four years on?