I'm wondering if an equivalent of the type SERIAL exists in DB2 (V7 or V8).

Thanks for your help

Hi geoffrey,

Please read Must Read before posting

Grofaty

(same player play again)

I'm using DB2 V7 and V8 on different Unix system (AIX, Sun, Linux,...).

SQL offers the possibility of defining a data type SERIAL
(SERIAL(n) : The SERIAL data type stores a sequential integer assigned automatically by the database server when a row is inserted. A SERIAL data column is commonly used to store unique numeric codes (for example, order, invoice, or customer numbers). SERIAL data values require 4 bytes of storage.)

And I'm wondering if there is an equivalent of this type in DB2. (GENERATED ALWAYS ???).

Thanks in advance

There are two options, IDENTITY and SEQUENCE ...

There is an article comparing these two types in developer domain www7b.boulder.ibm.com/dmdd ...

Cheers
Sathyaram

Thx for your help, i'll use GENERATED BY DEFAULT AS IDENTITY in my tests.