Hi Stephane,

The datatype you select is really based upon the scale and precision you
expect for the column. Typically I use 'integer' or 'decimal' but this is
mostly out of habit.

Oliver Mefford
Senior DBA, Corporate Database Services (CDS)
PeopleSoft, Inc. Data Center Facility
5840 Owens Drive, Pleasanton, CA. 94588
Office - 925/694-9011
Cell - 925/895-6384






"Stephane Paquette"
<stephane.[Email Address Removed] To: "DB2 UDB LazyDBA" <[Email Address Removed]
ardlife.ca> cc:
Subject: Number datataype
12/04/2003 06:58 AM







Hi,

DB2 UDB 8.1/AIX
In Oracle, numeric datatype is number only. In DB2 there are multiple
choices : smallint, int, float, ... and decimal.

In DB2, is there a better way ?
Can I use decimal for everything ? For example: decimal (5,0) instead of
int , do I loose something ?



Stephane Paquette
Administrateur de bases de données
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470
stephane.[Email Address Removed] <mailto:stephane.[Email Address Removed] CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page