For DB2: What does it mean when the column definition has ALWAYS GENERATED AS IDENTITY defined?
Article ID: KB0085427
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
It is a DB2 feature that will assign a sequential unique number to the column whenever a row inserts into the table. DB2 will guarantee uniqueness when a unique index creates for the column. The column ADB_SEQUENCE in each publishing table implements this solution to guarantee chronological sequence of events. However, there can only be one column of this kind in a table.
It is a DB2 feature that will assign a sequential unique number to the column whenever a row inserts into the table. DB2 will guarantee uniqueness when a unique index creates for the column. The column ADB_SEQUENCE in each publishing table implements this solution to guarantee chronological sequence of events. However, there can only be one column of this kind in a table.
Issue/Introduction
For DB2: What does it mean when the column definition has ALWAYS GENERATED AS IDENTITY defined?
Feedback
Yes
No
Powered by
