On 23.1.2017. 15:44, Loon, Eric van (ITOPT3) - KLM wrote: > Hi TSM/SP-ers! > I have something weird when using te following SQL queries: > > select sum(fs_used_size),sum(fs_total_size) from sysibmadm.snapstorage_paths > > Unnamed[1] Unnamed[2] > --------------------- --------------------- > 74434565120 692060160000 > > Now, when I try to calculate a percentage, I get the following result: > > tsm: AMSE3>select cast(sum(fs_used_size)*100/sum(fs_total_size)as > decimal(3,1)) > from sysibmadm.snapstorage_paths > > Unnamed[1] > ---------- > 10.0 > > That is not correct, 74434565120 *100 / 692060160000 = 10.75... What am I > doing wrong here? > Thanks for any help in advance!
Missing FLOAT statement and greater DECIMAL range? select cast(FLOAT(sum(fs_used_size))*100/sum(fs_total_size)as decimal(4,2)) from sysibmadm.snapstorage_paths Regards, -- Sasa Drnjevic www.srce.unizg.hr > Kind regards, > Eric van Loon > Air France/KLM Storage Engineering > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain confidential > and privileged material intended for the addressee only. If you are not the > addressee, you are notified that no part of the e-mail or any attachment may > be disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. If you > have received this e-mail by error, please notify the sender immediately by > return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission of > this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** >
