Scott, Joachim, That's the feature I was looking for. Thanks for the information!
Regards, Hanne -----Urspr�ngliche Nachricht----- Von: Scott Saunders [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 29. Oktober 2001 15:00 An: [EMAIL PROTECTED] Betreff: RE: DB2EUG: autoincrement? 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 ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
