Skip to Content
Oct 26, 2019 at 11:03 AM

packed decimal casting error in open SQL MOD function

227 Views Last edit Oct 26, 2019 at 11:04 AM 2 rev

hi all,

when i was trying to use packed decimal in MOD() Open SQL function i am getting error as

Data:  op2(2) TYPE p DECIMALS 2 VALUE '2.50'.
      SELECT SINGLE MOD( 10, CAST( @op2 AS INT2 ) ) AS f_div
              FROM snwd_bpa.

how can i achive above MOD operation with packed decimals.

thanks in advance.


error.png (14.0 kB)