DB2十进制除法 [英] DB2 Decimal Division

问题描述

大家好，

我很难在DB2存储过程中进行简单的划分.

我正在使用Data Studio并正在使用DB2 z/OS v9.1

我的变量:
-------------
值小数(18,13)
total_value十进制(18,13)
小数百分比(12，9)

简单划分:
--------------
百分比=值/总值* 100

我的价值观:
----------
值= 45.23
total_value = 57.35

预期结果:
----------------
百分比= 78.866608544

我将百分比设为零.花了几个小时浏览后，我发现

http ://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic =/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_decimaldivision.htm [ ^ ]

我无法完全理解，但发现它与精度和规模有关.
然后我玩了，最后我通过
得到了结果 (cast(值作为小数(15,13))/cas(总值作为小数(22,9))*100.

现在我发现我不应该抛弃那些价值观.

还有其他无需铸造就可以得到结果的方法吗??
请尽快答复.......寻找解决方案

Hi All,

I am having tough time doing a simple division in DB2 Stored procedure.

I am using Data studio and working on DB2 z/OS v9.1

My variables:
-------------
value Decimal(18,13)
total_value Decimal(18,13)
Percentage Decimal(12, 9)

Simple Division:
--------------
Percentage= value/total_value * 100

My values:
----------
value = 45.23
total_value = 57.35

Expected Result:
----------------
percentage = 78.866608544

I am getting the percentage as zero. After spending few hrs on browsing I found

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_decimaldivision.htm[^]

I couldn''t able to understand completely but figured out it has to do with precision and scale.
then I played with it and finally i got the result by doing
(cast(value as decimal(15,13)) / cas(total_value as decimal(22,9)) * 100.

Now i found that i am not supposed to cast those values .

Is there any other way of getting result without casting????
Please respond ASAP.......Looking after the solution

推荐答案

自从我上次使用DB2以来已经很久了，但是如果您更改了DB2，会发生什么情况?精度为百分比.因此，代替:

It''s been ages since I last used DB2, but what happens if you change the precision for the percentage. So instead of:

Percentage Decimal(12, 9)

使用

use

Percentage Decimal(18, 13)

或更高.

or higher.

这篇关于DB2十进制除法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！