Helpful Information
 
 
Category: DB2 Development
help needed in simple sql -DB2 database

Hi,
I have a table with double datatype column and i want to read the data in a user readable format.How can i achieve this.

db2 => create table test(col1 double)
db2 => insert into test values(12344578901234567890.12)
db2 => insert into test values(1234457890123456789012345.12)
db2 => insert into test values(123445789012345678901234567.12)
db2 => insert into test values(1234457890123456789012345678.12)

db2 => select * from test

COL1
------------------------
+1.23445789012346E+019
+1.23445789012346E+024
+1.23445789012346E+026
+1.23445789012346E+027


When i select the records I want to display the records in a user readable format like

12345678901234567890123456789.12
12345678901234567890123456789.12
12345678901234567890123456789.12
12345678901234567890123456789.12


How can i achieve this,can anyone give me the code for this










privacy (GDPR)