Steph,

You can use identity functionality to generate primary_keys. Please also
look into creating sequence.
Make sure varchar columns are not at the end of table. Place the most
frequently manipulated columns at the end of the table, put varchar columns
before the most frequently manipulated columns.

Decimal/int/smallint/bigint
Pleae read the whitepaper on converting Oracle ot DB2 there is a caution on
that don't remember on the top of my head.


HTH
Naushad




-----Original Message-----
From: Stephane Paquette [mailto:stephane.[Email Address Removed] Thursday, October 24, 2002 10:02 AM
To: [Email Address Removed] Table creation


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