Hanne; DB2 V7 supports the use of Identity columns for this purpose. This is a clause on the column definition of a Create Table statement that can auto-increment by whatever value you define.
HTH, Regards, Scott Saunders Siebel Systems, Inc. Opinions expressed are my own and not those of my employer. -----Original Message----- From: Hanne Hagedorn [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 3:28 AM To: [EMAIL PROTECTED] Subject: DB2EUG: autoincrement? Hi List, in Oracle I use sequences to fill my PK columns with an incrementing number. How could I do this in DB2? Is there anything like Oracle sequences or like the autoincrement feature in MySQL or do I have to use triggers or something? Any help appreciated! Thanks, Hanne ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
