Re: SQL question (Autoincrementing value.)

From: Kent Milligan <kmill_at_us.ibm.com>
Date: 2000/01/31
Message-ID: <38959A26.3222FE82_at_us.ibm.com>#1/1

Right now the best way to do an auto-increment field in DB2 UDB for AS/400 is to create a before trigger program (with ALWREPGCHG(*YES)) that increments the field value for you.

-- 
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, AS/400
kmill_at_us.removethis.ibm.com      GO HAWKEYES!! 
(opinions stated are not necessarily those of my employer)

Received on Mon Jan 31 2000 - 00:00:00 CET

This message: [ Message body ]
Next message: Thomas Tuft Muller: "Re: SQL question (Autoincrementing value.)"
Previous message: Peter Rogan: "Re: Enforcing Business Rules"
In reply to: Ron Stow: "SQL question (Autoincrementing value.)"
Next in thread: Thomas Tuft Muller: "Re: SQL question (Autoincrementing value.)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message