Identity columns

Hi,

It appears that I cannot add an identity column to an existing DB2/400
file that was created via DDS instead of being created as an SQL table.

When adding to an SQL table it works fine, for example -

 

ALTER TABLE peter/myvar  ADD COLUMN AUDITID INTEGER NOT NULL

GENERATED ALWAYS AS IDENTITY                                

ALTER completed for table MYVAR in PETER.  

 

But when adding to a DDS generated file the SQL0372 error is issued, for
example -

 

ALTER TABLE peter/audpf0 ADD COLUMN AUDITID INTEGER NOT NULL        

GENERATED ALWAYS AS IDENTITY                                        

Only one ROWID or IDENTITY column allowed for table AUDPF0 in PETER. 

 

However, the SQL0372 error is spurious since there is obviously no
existing identity column on the existing DDS created file.

I'm prepared to accept the fact that attempting to do this is not
allowed but I can find no documentation that says so.

Can anyone verify this?

 

Peter                 


#####################################################################################
This correspondence is for the named person's use only. It may contain 
confidential or legally privileged information, or both. No confidentiality or 
privilege is waived or lost by any mistransmission. If you receive this 
correspondence in error, please immediately delete it from your system and 
notify the sender. You must not disclose, copy or rely on any part of this 
correspondence if you are not the intended recipient. Any views expressed in 
this message are those of the individual sender, except where the sender 
expressly, and with authority, states them to be the views of Baycorp 
Advantage. If you need assistance, please contact Baycorp Advantage on either 
:- Australia 133124 or New Zealand +64 9 356 5800