MVSFORUMS.com

viji · Beginner Joined: 03 Dec 2002 Posts: 17 Topics: 11

Hi,
I have two columns A & B defined as Integer in a DB2 table. Now i need to calculate (A/B)*100......When I do this the decimal part gets truncated!!! this could be because the original column(A & B) was defined as "INTEGER" . How can I overcome this.

For example when A=19 & B=22 then
I need (A/B)*100 = 86.36 But I am getting 80

Thanks

kolusu · Posted: Tue Jul 22, 2003 10:22 am Post subject:

Viji,

If both operands of an arithmetic operator are integers, the operation is performed in binary and the result is a large integer. Any remainder of division is lost. The result of an integer arithmetic operation (including unary minus) must be within the range of large integers.

So inorder to have a decimal portion convert one of the integer to a decimal and you will get the result as a decimal

try this

kolusu · Posted: Tue Jul 22, 2003 5:21 pm Post subject:

Viji,

You also need to be careful about the "division by zero" errors. You can use a CASE statement to avoid the division by zero error.The following sql will initialize the divide value to a null(value unknown) if the contents of the column B is zero. If the contents of b is any thing other than zero , it performs the division and puts the value with the decimals.

viji · Beginner Joined: 03 Dec 2002 Posts: 17 Topics: 11

Thanks Kolusu, Your solution solved my problem!!!!!!
Thanks once again.... Razz