| <html lang=en> |
| <head> |
| <meta name="Generated by Rational Rose model" content="C:\Aurora_Oct20\RSM\eclipse\workspace-cascadeplus\org.eclipse.wst.rdb.models.dbdefinition\src\model\DatabaseDefinitionModel.mdl"> |
| <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> |
| <meta name="Description" content="4.14.4 Identity columns The columns of a base table BT can optionally include not more than one identity column. The declared type of an identity column is either an exact numeric type with scale 0 (zero), INTEGER for example, or a distinct type whose source type is an exact numeric type with scale 0 (zero). An identity column has a start value, an increment, a maximum value, a minimum value, and a cycle option. An identity column is associated with an internal sequence generator SG. Let IC be the identity column of BT. When a row R is presented for insertion into BT, if R does not contain a column corresponding to IC, then the value V for IC in the row inserted into BT is obtained by applying the General Rules of Subclause 9.21, Generation of the next value of a sequence generator , to SG. The definition of an identity column may specify GENERATED ALWAYS or GENERATED BY DEFAULT. NOTE 24: Start value , increment , maximum value , minimum value , and cycle option are defined in Subclause 4.21, Sequence generators . NOTE 25: The notion of an internal sequence generator being associated with an identity column is used only for definitional purposes in this International Standard."> |
| <meta name="KeyWords" content="IdentitySpecifier,Class IdentitySpecifier,DatabaseDefinitionModel,model DatabaseDefinitionModel,"> |
| <a href="../../../root.html" target=_top><IMG SRC="../../../webviewer/home.gif"BORDER=0></a> |
| </head> |
| <body bgcolor = "#FFFFFF"> |
| <p><font FACE="Arial, Geneva" SIZE=3><b>Class IdentitySpecifier {Analysis}</b></font></p> |
| <font FACE="Arial, Geneva" SIZE=2><b>Documentation</b></font><BR><font FACE="Arial, Geneva" SIZE=2>4.14.4 Identity columns |
| <BR> |
| <BR>The columns of a base table BT can optionally include not more than one identity column. The declared type of an identity column is either an exact numeric type with scale 0 (zero), INTEGER for example, or a distinct type whose source type is an exact numeric type with scale 0 (zero). An identity column has a start value, an increment, a maximum value, a minimum value, and a cycle option. |
| <BR> |
| <BR> |
| <BR>An identity column is associated with an internal sequence generator SG. Let IC be the identity column of BT. When a row R is presented for insertion into BT, if R does not contain a column corresponding to IC, then the value V for IC in the row inserted into BT is obtained by applying the General Rules of Subclause 9.21, "Generation of the next value of a sequence generator", to SG. The definition of an identity column may specify GENERATED ALWAYS or GENERATED BY DEFAULT. |
| <BR> |
| <BR>NOTE 24: "Start value", "increment", "maximum value", "minimum value", and "cycle option" are defined in Subclause 4.21, "Sequence generators". |
| <BR> |
| <BR>NOTE 25: The notion of an internal sequence generator being associated with an identity column is used only for definitional purposes in this International Standard.</font><BR><BR> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Parent Package</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="cat3f27d66b01ab.htm" target="contents_frame">Schema</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Abstract</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>No</font></TD></TR><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Export Control</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>PublicAccess</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Link Class for</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>None</font></TD></TR><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Class Kind</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>NormalClass</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Cardinality</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>n</font></TD></TR><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Space</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Concurrency</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>Sequential</font></TD></TR><TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Persistence</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>No</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR></TABLE><BR><BR> |
| <font FACE="Arial, Geneva" SIZE=2><b>Attributes</b></font> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Name</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Class</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Type</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Initial Value</b></font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ed23c620340.htm" target="contents_frame">generationType</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea40dbd02b7.htm" target="contents_frame">GenerateType</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ea3f3d30042.htm" target="contents_frame">startValue</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>int</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ea40cf903da.htm" target="contents_frame">increment</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>int</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ea40d14035c.htm" target="contents_frame">minimum</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>int</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ea40d2a00ab.htm" target="contents_frame">maximum</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>int</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/30.jpg"BORDER=0><a href="att3ea40d2f01e3.htm" target="contents_frame">cycleOption</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>boolean</font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| </TABLE><BR><BR> |
| <font FACE="Arial, Geneva" SIZE=2><b>Associations</b></font> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Name</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>My Role</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>My Class</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Other Role</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>Other Element</b></font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><a href="../../../looseends/ass3edf921303ad.htm" target="contents_frame">--Not Named--</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/priv.gif"BORDER=0><a href="../../../looseends/role3edf92150264.htm" target="contents_frame">identitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/priv.gif"BORDER=0><a href="../../../looseends/role3edf92150245.htm" target="contents_frame">--Not Named--</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="../cat4071d00f009f/class3e9b2aff0392.htm" target="contents_frame">Column</a></font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><a href="../../../looseends/ass3fabf06600ac.htm" target="contents_frame">--Not Named--</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/pub.gif"BORDER=0><a href="../../../looseends/role3fabf067022a.htm" target="contents_frame">identity</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3ea3f30101d3.htm" target="contents_frame">IdentitySpecifier</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><IMG SRC="../../../webviewer/pub.gif"BORDER=0><a href="../../../looseends/role3fabf0670234.htm" target="contents_frame">--Not Named--</a></font></TD><TD><font FACE="Arial, Geneva" SIZE=2><a href="class3fabf02b03cd.htm" target="contents_frame">Sequence</a></font></TD></TR> |
| </TABLE><BR><BR> |
| <BR><p><font FACE="Arial, Geneva" SIZE=3><b>Property Settings</b></font></p> |
| <font FACE="Arial, Geneva" SIZE=2><b>Data Modeler</b></font> |
| <TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>dmItem</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>DMName</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>IsTable</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>IsView</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>IsDomain</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>IsSPPackage</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>Synonymns</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>TableSpaceID</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>SourceId</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>SourceType</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>CorrelationName</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>SelectClause</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>IsUpdateable</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>True</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>CheckOption</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>None</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>IsSnapShot</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>IsDistinct</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| <TR><TD><font FACE="Arial, Geneva" SIZE=2><b>PersistToServer</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2> </font></TD><TD><font FACE="Arial, Geneva" SIZE=2><b>IsPackage</b></font></TD><TD><font FACE="Arial, Geneva" SIZE=2>False</font></TD></TR> |
| </TABLE><BR><BR> |
| </body> |
| </html> |
