Re: AW: status of AUTO_INCREMENT in SQL

On Tue, 14 Jun 2005, HauserSSS wrote:

> You want to have a column, that is automatically filled with the next
> numeric value, if a record is written to the file?
> If so, you have to define an identity column.
>  CREATE TABLE MySchema/CUSTMASTR (
>         CUSTOMER_NUMBER FOR COLUMN CUSNBR INTEGER
>                         GENERATED ALWAYS AS IDENTITY (
>                         START WITH 10 INCREMENT BY 10
>                         NO MINVALUE NO MAXVALUE
>                         CYCLE ORDER
>                         CACHE 20 ),
> Whenever a row is inserted, the customer_number is automatically determined
> and inserted.

That looks great. Thank you very much. Maybe this is some much more
general method for generating field values or something. Elsewhere like
mysql and postgresql, that idea is accomplished just by saying that the
field is auto_increment.

Thank you.
brian.