I want to create a table with a surrogate key (auto incremented) as a
primary key. Is there any function that is available in DB2 so that when I
delete a row from the table it will adjust the key? For example if my table
contains rows in a order



Key

---

1

2

3



If the row #2 is deleted then order should be



Key

---

1

2



Will it be possible in DB2?



Thanks & Regards,

Ruben Prakash Durairajulu

US Technology

Office: +91-471-2335777(Extn: 2479)

Mobile: +91-98951-36027
Fax: +91-471-2527276


<http://ustri.com/> http://ustri.com

Disclaimer:This e-mail and any files transmitted with it are for the sole
use of the intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.
Failure to maintain the confidentiality of this e-mail and any attachment
may subject you to penalties under applicable law..






DB2 & UDB email list listserv db2-l LazyDBA home page