#84 DB2 DECFLOAT values shown as <Other>

[Georg Hartmann]

Hi,

I'm using Squirrel (snapshot-20160108_2306) against a DB2 10.5.7 LUW database where we have some columns with data type DECFLOAT.
Squirrel shows these values as <Other> instead with their numeric representation.
getColumnClassName is java.math.BigDecimal
getColumnType is 1111

As test you can use

select
cast(176.8 as DOUBLE) as value1,
cast(176.8 as DECFLOAT(34)) as value2 ,
cast(176.8 as DECFLOAT(16)) as value3
FROM sysibm.SYSDUMMY1

I've seen that there was a comment about DECFLOAT in the mailing list back in 2015 but I haven't found any other hint.

Kind regards

Georg

[Gerd Wagner]

You created a patch ticket but there is no attachment. Did you forget to upload your patch?

[Georg Hartmann]

Hello Gerd,
unfortunately I didn't recognize that the categories also belong to "create ticket".
I just wanted to open a ticket to ask whether this behavior is a bug or intended, as I've seen this entry in the mailing list that announced a patch for this data type.

Kind regards
Georg

[Pablo Gus]

Hi all,

Is there any solution for this issue? We have the same situation here. We update Squirrel to the latest version and still happening.

Thanks! Regards,
Pablo.

[Gerd Wagner]

Cannot be reproduced on "DB2 UDB for AS/400", see http://pub400.com/, and driver "AS/400 Toolbox for Java JDBC Driver"

[Georg Hartmann]

Hello Gerd,
as written in the inital message we use db2 LUW which is quite different to AS/400
Currently we use IBM DB2 Developer-C v11.1.4 with its db2jcc4.jar (4.25.13 https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads)
used in squirrel-sql-snapshot-20190714_0016-standard.jar and the described behavior is still present.

regards
Georg

[Gerd Wagner]

Sorry, now I can reproduce your problem even on DB2 for AS 400.

Please go to menu File -> Global Preferences -> tab Data Type Controls -> section SQL Other and check "Read contents when table is first loaded and display as string"