Hi,

After 13 years with Oracle, I'm trying DB2 (UDB 7.2).
I have to do the physical model.

Is it ok to use the identity functionnality to generate primary keys ? (we
may use the loader to bulk load data from flat files)

Is it better to use decimal (x.0) or to use int,smallint or biggint ?

Is there an order for the columns in a table, not null at the beginning and
null at the end ?

Any other tips for creating tables ?


TIA


Stéphane Paquette
Administrateur de bases de données

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 499-7948

stephane.[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page