I Have a table with definition :
CREATE TABLE "ABC"."XYZ" ("PRICE" DOUBLE NOT NULL);
and i inserted one record as :
db2 "insert into ABC.XYZ (PRICE) values (4.789928258849587598785605)"
Now when i do "select PRICE from ABC.XYZ" it gives o/p as :
PRICE
------------------------
+4.78992825884959E+000
1 record(s) selected.
But i want o/p value same as "4.789928258849587598785605" (which i inserted).
How can i get the same value ?
Any help would be appreciated ...
CREATE TABLE "ABC"."XYZ" ("PRICE" DOUBLE NOT NULL);
and i inserted one record as :
db2 "insert into ABC.XYZ (PRICE) values (4.789928258849587598785605)"
Now when i do "select PRICE from ABC.XYZ" it gives o/p as :
PRICE
------------------------
+4.78992825884959E+000
1 record(s) selected.
But i want o/p value same as "4.789928258849587598785605" (which i inserted).
How can i get the same value ?
Any help would be appreciated ...