dc_settings: Data Cache Settings
read only
- Katalog:
Cache - Schema:
Invantive - Primärschlüssel:
stg_id - Label: Settings
Central configuration of the software consisting of settings and defaults for configuration of other objects such as tables.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle dc_settings 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 |
|---|---|---|---|---|---|
stg_ |
varchar2 |
Automatisches Upgrade zulassen | Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on every new connection to the backing database. | ||
stg_ |
varchar2 |
Einmal automatisch upgraden | Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on the next connection established to the backing database. | ||
stg_ |
varchar2 |
Erstellt in | The code of the function in the modules table from within which the user created the record.This value will never change after creation of the record. | ||
stg_ |
varchar2 |
Erstellt durch | Wer hat den Datensatz erstellt. | ||
stg_ |
datetime |
Erstellt bei | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
stg_ |
datetime |
Aktualisiert am | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
stg_ |
varchar2 |
Dummy | Placeholder for a unique value to ensure uniqueness and at most one row in this table. | ||
stg_ |
varchar2 |
Umgebungs-ID | Unique environment ID. | ||
stg_id |
decimal |
ID | Unique identifier. | ||
stg_ |
char |
Index – Fakten – Tabellen | Default whether indexes on facts tables must be created and maintained. | ||
stg_ |
char |
Index-Verlaufstabellen | Default whether indexes on history tables must be created and maintained. | ||
stg_ |
char |
Gesamtlogische Views pflegen | Default whether overall logical views must be created and maintained. | ||
stg_ |
varchar2 |
Name der logischen Gesamtview von Postfix | Default postfix for the name of the overall logical view. | ||
stg_ |
varchar2 |
Präfix Gesamtname der logischen View | Default prefix for the name of the overall logical view. | ||
stg_ |
char |
Logische Views von Partitionen verwalten | Default whether partition logical views must be created and maintained. | ||
stg_ |
varchar2 |
Name der logischen View der Postfix-Partition | Default postfix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Präfix Partition Name der logischen View | Default prefix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Aktualisiert in | The code of the function in the modules table from within which the user last updated the record.This value will change for every mutation of the record. | ||
stg_ |
varchar2 |
Aktualisiert von | The name of the user in the users table whom last updated the record.This value will change for every update of the record. | ||
stg_ |
varchar2 |
Original System Gruppe | Reference for identifying the group of records on the system from which it originated.It is commonly used to group records for later validation in an application control. | ||
stg_ |
varchar2 |
Ursprünglicher Systembezug | Referenz zur Identifikation des Datensatzes auf dem System, von dem er stamm. | ||
stg_ |
decimal |
Sekunden vor „Droppable“ | Number of seconds after becoming obsolete before a table partition-specific facts table is droppable. | ||
stg_ |
decimal |
Sekunden vor dem Aus | Number of seconds after download before the downloaded data is considered obsolete. | ||
stg_ |
decimal |
Sekunden vor dem Löschen der Metadaten | Number of seconds after the data became obsolete before the metadata is droppable. | ||
stg_ |
decimal |
Aufbewahrungsdauer in Sekunden für weitergeleitete eingehende Nachrichten | Number of seconds after an incoming messages has been forwarded before becoming eligible for a delete. | ||
stg_ |
varchar2 |
Session erstellt | The ID of the session which created the record.This value will not change after insert. | ||
stg_ |
varchar2 |
Sitzung aktualisiert | Die ID der Session, die den Datensatz zuletzt aktualisierte. | ||
stg_ |
varchar2 |
Version der SQL-Engine | Version of the SQL engine used to update the repository data model. | ||
stg_ |
varchar2 |
Token | Token for authentication to download messages from the Customer Service. | ||
stg_ |
varchar2 |
Verhandlung angelegt | The ID of the transaction which created the record. | ||
stg_ |
varchar2 |
Verhandlung aktualisiert | The ID of the transaction which last updated the record. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: