Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Add an auto-increment field to an existing file

How do I add an auto-increment field to an existing file?

The syntax is:
ALTER TABLE tablename ADD COLUMN colname INTEGER GENERATED ALWAYS AS IDENTITY

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.


Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close