Yes they introduced this feature in 7.1. Excerpt from DB2 manual What's New Identity Column Support <frm3toc.htm> DB2 now allows you to generate a unique numeric value for each row in a table. For example, an identity column can be used to generate unique primary key values. You can also port applications that use identity columns from other RDBMS vendors to DB2. See the Administration Guide: Implementation for more information. DB2 Version 7.2 enhances identity column support in its use with load. After loading data into a table with identity columns, you can use the ALTER TABLE statement to restart the sequence of values assigned to the identity column at the correct value. See ALTER TABLE in the DB2 Release Notes for the new syntax of the ALTER TABLE statement that supports this enhancement.
____________________ Glenn Pinto BB&T IS-Alternative Delivery Systems * mailto:[EMAIL PROTECTED] *(919) 716-9305 > -----Original Message----- > From: Jissy [SMTP:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 2:43 AM > To: JDJList > Subject: [jdjlist] DB2 Related > > Hi All > > Is there an equivalent of INENTITY columns in MSSql Server and Sequences > in Oracle, in DB2? > > Or can anyone refer me to any link where I can post this question? > > Regards > Jissy > To change your membership options, refer to: > http://www.sys-con.com/java/list.cfm To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
