Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

packed decimal casting error in open SQL MOD function

Balu483
Participant
0 Kudos

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.

1 REPLY 1

Sandra_Rossi
Active Contributor
0 Kudos

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