Hi all -

How can you retain the values in an existing ID field that's:
"PARTICIPANTS_ID" INTEGER NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 0, INCREMENT BY 1, NO CACHE,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),

When you want to make the IDs for new values automatically generate? I
backed this table up and then changed it to:

"PARTICIPANTS_ID" INTEGER NOT NULL GENERATED ALWAYS
AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE,
NO MINVALUE, NO MAXVALUE, NO CYCLE, NO ORDER),

and as you might've guessed, it renumbered the table. ouch! So, I can
restore, but I need to be able to insert new values w/o manually
assigning IDs. What am I missing here?

Thanks.


DB2 & UDB email list listserv db2-l LazyDBA home page