RE: primary key to generate unique incremental number in DB2

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 is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.