packed decimal casting error in open SQL MOD function

Balu483 — Sat, 26 Oct 2019 11:03:48 GMT

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.

Re: packed decimal casting error in open SQL MOD function

Sandra_Rossi — Sat, 26 Oct 2019 13:25:47 GMT

You mean, how to complete the upgrade to (kernel) release 745...