Concepts > Attributes (MetaAttributes) > AS ROW \ DB2 10.5
AS ROW \ DB2 10.5
AS ROW BEGIN
Specifies that the value is assigned by the database manager
whenever a row is inserted into the table or any column in the row
is updated. The value is generated using a reading of the
time-of-day clock during execution of the first of the following
events in the transaction:
- A data change statement that requires a value to be assigned to
the row-begin or transaction start-ID column in a table
- A deletion of a row in a system-period temporal table
 
AS ROW END
Specifies that a value for the data type of the column is assigned
by the database manager whenever a row is inserted or any
column in the row is updated. The assigned value is TIMESTAMP
'9999-12-30-00.00.00.000000000000'.
A row-end column is required as the second column of a
SYSTEM_TIME period, which is the intended use for this type of
generated column.
A table can have only one row-end column (SQLSTATE 428C1). If
data-type is not specified, the column is defined as
TIMESTAMP(12). If data-type is specified, it must be
TIMESTAMP(12) (SQLSTATE 42842). The column must be defined
as NOT NULL (SQLSTATE 42831). A row-end column is not
updatable.
 
Translations
Type
String (5) Enumeration
 
List of MetaClasses
Value
(BEGIN), (END).