Re: Another JDBC (and by extension, JDBCR4) meta-data retrieval question

On Fri, Apr 5, 2013 at 2:26 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

I presume the /displayed/ results are giving a false impression.
What interface was being used to draw that conclusion was unstated, but
presumably it was likely either a Display File or the Query/400 report
writer; DFU as I recall, does not have support for Float.

You're right. I happened to be using Query/400.

Depending on the interface used to /display/ the effects of the
specification, the results can change; i.e. not all interfaces will
present the human-readable form of the floating point representation
with the specified number of decimal digits and decimal digits after the
decimal point.

Yeah. Query/400 happens to honor the preference, in its way. I see
that DBU also tries to, in its way; which happens to make manual entry
of many valid values impossible.

So float-handling is kind of a crap shoot. This is further
disincentive, in my book, to defining float fields on the i,
particularly in DDS. (The main disincentive being the
counterintuitive (to most people) and often undesired arithmetic
behavior.)

John