Modulus Operator Help

dinjo_jo · #1 (**permalink**) 12-16-09, 00:42

I'm trying to do a modulus on DB2 but it fails % is not a valid

and (COLA/COLB)%10 != 0

tonkuma · #2 (**permalink**) 12-16-09, 01:07

Mod(cola/colb, 10)

dinjo_jo · #3 (**permalink**) 12-16-09, 01:34

It says no aothorized routine named Mod of type function having compatible arguments were found.

tonkuma · #4 (**permalink**) 12-16-09, 02:20

What are the data types of cola and colb?

What platform and DB2 version/release are you using?

Here is an example on DB2 9.7 for Windows.

Code:

------------------------------ Commands Entered ------------------------------
SELECT cola , colb
     , cola / colb        division
     , MOD(cola/colb, 10) modulus
  FROM(VALUES (191, 13) ) r(cola, colb);
------------------------------------------------------------------------------

COLA        COLB        DIVISION    MODULUS    
----------- ----------- ----------- -----------
        191          13          14           4

  1 record(s) selected.

dinjo_jo · #5 (**permalink**) 12-16-09, 02:51

Both columns are decimal

tonkuma · #6 (**permalink**) 12-16-09, 02:55

DB2 9.7.1 Express-C on Windows.

Code:

------------------------------ Commands Entered ------------------------------
SELECT cola , colb
     , cola / colb        division
     , MOD(cola/colb, 10) modulus
  FROM(VALUES (191.9, 13.1) ) r(cola, colb);
------------------------------------------------------------------------------

COLA   COLB  DIVISION                          MODULUS    
------ ----- --------------------------------- -----------
 191.9  13.1    14.648854961832061068702290076           4

  1 record(s) selected.