I do agree but the customers and users do not!
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
Link zur Datenschutzerklärung
Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich
> On 19 Jun 2019, at 16:16, Michael Hannan
<[login to unmask email]> wrote:
> No, it is not obvious to me that cast necessarily loses all
the data in the darn thing. Yes loses precision and rounding
perhaps, I see double Float is limited to 8 bytes 64 bits, where
DECFLOAT can be 16 bytes. However what is all that extra precision
for (max precision of 31 digits)? Nothing can be measured that
accurately. Seems like useless precision. If the number is just a
set of digits not measuring anything, then DECFLOAT is an
unsuitable way to store it.
> Supposing I could recite the first 31 digits of Phi, being
3.14159265358979 32384626 4338327950288 is that useful for
anything? Whoops just over 31 digits. Only to show off if I in fact
remembered it (I knew the first bit but cheated for the last bit).
Nah, it is no earthly use.
> Just because a feature exists in DB2, does not mean we should
use it. It is about sensible use, surely? I can see the problem for
third party products to support it much.
> I suppose you might want a Catalogue query to show the
Frequent Value Stats in readable display form. I wrote SQL code to
translate internal INTEGER, SMALLINT, and even FLOAT values stored
in a LOW2KEY or Freq Value COLVALUE to displayable format, but must
admit I did not see a need to support DECFLOAT. Could just dump it
as hex string.
> I would strongly recommend not using DECFLOAT for any column
having predicates, that might need to be indexed.
> Just because we have Scrollable Cursors, does not mean its a
good idea to use them. Just because we have index compression
possible, does not mean we should use it.
> Michael Hannan,
> DB2 Application Performance Specialist
> CPT Global Ltd
> Site Links: View post online View mailing list online Start
new thread via email Unsubscribe from this mailing list Manage your
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 &
the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log
Analysis, TDM, & more.
> Use of this email content is governed by the terms of service