× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.