invantive documentation
Invantive SupportforenAnmelden / Eintragen

SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: Rows Changed in Session

Audit of rows changed in a session.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SESSIONROWSCHANGED sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
COLUMN_1 varchar2 Spalte 1 Name of the first column being updated.
DURATION_MS double Duration Duration in milliseconds of the change.
ERROR_MESSAGE varchar2 Fehlermeldung Error message that occurred during executing the change.
EXECUTION_DATE_UTC datetime Datum erstellen Date at which the change was executed (UTC).
ID int32 ID Unique ID of the change.
NEW_VALUE_TEXT_1 varchar2 New Value 1 New value of the first column.
OLD_VALUE_TEXT_1 varchar2 Old Value 1 Old value of the first column.
PARTITION varchar2(30) Partition Specific partition on which the change was executed.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
SQL_REVERT varchar2 SQL Revert SQL statement to revert all columns changed.
SUCCESSFUL char Succesful Indicator whether the change completed successfully.
TABLE_NAME varchar2(240) Tabelle Name Name of the table or view.
TXN_ID int64 Transaktions-ID Transaction ID of the change.
UNIQUE_KEY_1 varchar2 Unique Key 1 Value of the first column of the unique key.
UNIQUE_KEY_2 varchar2 Unique Key 2 Value of the second column of the unique key.
UNIQUE_KEY_3 varchar2 Unique Key 3 Value of the third column of the unique key.
UNIQUE_KEY_4 varchar2 Unique Key 4 Value of the fourth column of the unique key.
UNIQUE_KEY_5 varchar2 Unique Key 5 Value of the fifth column of the unique key.
UNIQUE_KEY_6 varchar2 Unique Key 6 Value of the sixth column of the unique key.

Tasten

Key Column Bezieht sich auf Kind Description
SESSIONROWSCHANGED_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_txt PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Textual The data container of the change, while that data container is active; the history of changes outlives a data container that was closed.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: