Identity
Usage
To specify that this property corresponds to the identity column in the corresponding SQL table, use the following syntax:
Property name As %Integer [ Identity ];
The type of the property can be any integer type, for example, %BigInt, %Integer, %SmallInt, or %TinyInt.
Otherwise, omit this keyword or place the word Not immediately before the keyword.
Details
For a persistent object, this keyword specifies that a property corresponds to an identity column in the corresponding SQL table (that is, a column that is marked with the SQL IDENTITY keyword). This keyword is useful particularly for tables that are created through DDL statements. When creating a table using DDL, make sure that any IDENTITY field is defined with MINVAL=1, if possible, to allow the creation of a bitmap extent index. See “CREATE TABLE” in the Caché SQL Reference.
Default
If you omit this keyword, this property is not used as the identity column.
See Also
-
“Property Definitions” in this book
-
“Defining and Using Literal Properties” in Using Caché Objects
-
“Introduction to Compiler Keywords” in Using Caché Objects
