Data Dictionary Data ModelAudit of rows changed in a session.
Catalog: DataDictionary
Schema: Invantive
Alias: srd
Label: Rows Changed in Session
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SESSIONROWSCHANGED are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
COLUMN_1 |
string |
Column 1 |
|
Name of the first column being updated. |
DURATION_MS |
int64 |
Duration |
|
Duration in milliseconds of the change. |
ERROR_MESSAGE |
string |
Error Message |
|
Error message that occurred during executing the change. |
EXECUTION_DATE_UTC |
datetime |
Creation Date |
|
Date at which the change was executed (UTC). |
ID |
int32 |
ID |
|
Unique ID of the change. |
NEW_VALUE_TEXT_1 |
string |
New Value 1 |
|
New value of the first column. |
OLD_VALUE_TEXT_1 |
string |
Old Value 1 |
|
Old value of the first column. |
PARTITION |
string(30) |
Partition |
|
Specific partition on which the change was executed. |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
SQL_REVERT |
string |
SQL Revert |
|
SQL statement to revert all columns changed. |
SUCCESSFUL |
boolean |
Succesful |
|
Indicator whether the change completed successfully. |
TABLE_NAME |
string(240) |
Table Name |
|
Name of the table or view. |
TXN_ID |
int64 |
Transaction ID |
|
Transaction ID of the change. |
UNIQUE_KEY_1 |
string |
Unique Key 1 |
|
Value of the first column of the unique key. |
UNIQUE_KEY_2 |
string |
Unique Key 2 |
|
Value of the second column of the unique key. |
UNIQUE_KEY_3 |
string |
Unique Key 3 |
|
Value of the third column of the unique key. |
UNIQUE_KEY_4 |
string |
Unique Key 4 |
|
Value of the fourth column of the unique key. |
UNIQUE_KEY_5 |
string |
Unique Key 5 |
|
Value of the fifth column of the unique key. |
UNIQUE_KEY_6 |
string |
Unique Key 6 |
|
Value of the sixth column of the unique key. |
17-05-2021 11:57 Version 20.1.419-BETA+3191
