Displaying DB2 Floats on Unix

[virtualjon]

Hi guys,

Just a quickie. I am using DB2 at the Unix command line, and when running sql queries, FLOAT fields are displayed in the output as:

+6.62557333433470E+001

rather than

66.25573334334702 etc, as stored in the database.

Is there any way to change the query in order to get the full value contained in the field?

All help gratefully received.

Cheers

Jon

 

[gregsimpson]

Jon,

try casting the value to char field. Would that help?

Cheers
Greg