Discussion :

[geoffrey_k]

Salut,

Je me demandais s'il existait un equivalent du type SERIAL en DB2 (V7 ou V8)

Merci

[geoffrey_k]

Precision - 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.

[Fabien Celaia]

IDENTITY ne vous va pas ?

[geoffrey_k]

Je vais essayer avec GENERATED [] AS IDENTITY.

Merci