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!

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

Storing fractional values in DB2

Status
Not open for further replies.
varshan09

varshan09

Programmer
Oct 28, 2003
45
IN
Hi,
Is there any way to store fractional values like 1/8 in the database. One way is to store in the form of string. We would like to know if there is any data type which supports storing fractional values in DB2.

thanks!
 
Sort by date Sort by votes
As far as I know, you can only store these as a CHAR string as DB2 does not support fractions in the fashion you require, although I am happy to proved wrong on this.

Marc
 
Upvote 0 Downvote
Not a datatype, no. But why not use two fields to store this? Simple division would return the fractional .....

T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
383
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
296
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
243
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
300
walter.weinmann
walter.weinmann
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
132
Rohit K Gupta
Rohit K Gupta

Part and Inventory Search

Sponsor

Back
Top