Anton Versteeg wrote:

> deebeetwo@yahoo.com wrote:
>
>> It seems that on AS/400, the IDENTITY option is not available. For
>> example, I cannot declare a column as "integer generated always as
>> identity".
>>
>> Is there an alternative that I can use? The numbers that I would like
>> generated do not need to be sequential.
>>
>> Thanks in advance!
>>
> What version are you on?
> If I am correct identity values are supported since V5R3
>
Correction: Since V5R2

--
Anton Versteeg
IBM Netherlands