Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

packed decimal casting error in open SQL MOD function

Balu483
Participant

‎2019 Oct 26 12:03 PM

0 Likes
1,128

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.

Preview file
14 KB
1 REPLY 1
Read only

Sandra_Rossi
Active Contributor

‎2019 Oct 26 2:25 PM

0 Likes
875

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