Re: How do I create a file with an Identity Column field as the key?

[Pete Helgren <Pete@xxxxxxxxxx>]

I have used STRSQL and have typically created the identity field with a 
separate alter table statement after creating the other columns (not 
sure *why * do it that way, now that I think about it).  The ALTER 
statement is similar to:

ALTER TABLE departments ADD COLUMN ID INTEGER NOT NULL generated
always as identity                                             

Maybe I can't specify the  "generated always as identity" in the STRSQL 
prompt so that is why I added the identity field separately.  I'd have 
to play with it to find out, but the alter table syntax does work for me.

Pete
                                    


Booth Martin wrote:
> How do I create a file with an Identity Column field as the key?
>
> Can this be done with STRPDM and DDS?
>