Identity Columns

An identity column is one of the following:
carcudb2
An 
identity column 
is one of the following:
  • Any column that is defined with a data type of DECIMAL, INTEGER, SMALLINT, or BIGINT
  • A distinct type that is sourced on the DECIMAL, INTEGER, SMALLINT, or BIGINT data types and whose column default indicator on the Table Alter, Create, or Template panel is set to A or D
For more information about identity columns, see the IBM 
SQL Reference
 or 
Administrator Guide
.
You can complete the following identity column related tasks:
  • Create Identity Columns
  • View or Update Identity Column Attributes
  • Determine the Default Value