Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I Have a table with definition : C

Status
Not open for further replies.

kulvant29

IS-IT--Management
Feb 4, 2016
1
GB
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 ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top