DSXchange

anbu wrote: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.

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.

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?