Re: primary key to generate unique incremental number in DB2

Hello,

I think only available from V5R2M0 or V5R3M0 ...

SRamanujan@xxxxxxxxxxxxxxxxxx wrote:

Hi Ashish,
You could use the RowId or Identity while creating the Table.  You could
also do the alter table.

Create table myTable (RECORDID ROWID NOT NULL <GENERATED ALWAYS>/<GENERATED BY DEFAULT>)

Create table MyTable (AutoNo <data type> <GENERATED ALWAYS>/<GENERATED BY DEFAULT> AS
IDENTTITY
START WITH - Optional INCREMENT BY - Optional )

Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax

-----Original Message-----
From: Ashish Kulkarni [mailto:kulkarni_ash1312@xxxxxxxxx] Sent: Monday, May 02, 2005 12:21 PM
To: java400-l@xxxxxxxxxxxx
Subject: primary key to generate unique incremental number in DB2

Hi
is it possible to define while creating a table to
have a unique incrementing number for primary key
for example, suppose i have when i enter first record
the primary key will be 1, then it will increment by 1

Ashish

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
-----------------------------------------------------------------------------
*** This messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne