Data Table Information (Read-Only Properties)
Getting there
Databridge Servers > Client Managers > Settings > Customize > (click on data set) > Relational > Settings > Information
The read-only properties for a data item are organized in the following sections:
Basic Properties
Dataset Name
This entry represents the value of the dataset_name column in the DATATABLES Client control table for the item.
Active
This entry represents the value of the active column in the DATATABLES Client control table for the item. This will normally be set to True, the only exceptions being items that are the tail ends of concatenations will have Active = False. The item must be present during a process command to extract the data for the concatenation.
Relational Info
This section has a single entry. Primary Table indicates whether or not the table is a primary table. Secondary tables are tables created for items where OCCURS clauses are not flattened or they are the result of a table being split into multiple tables because of restrictions in the relational database (e.g. limit on the maximum number or columns).
Options
This section primarily has one property. The remaining read-only properties are only shown when they are set to True.
History Table
Indicates whether or not the table is a history table. A History Table is a special table that maintains a record for every update.
Index Renamed by User
Indicates that the index_name column in the corresponding DATATABLES entry was modified.
Preserving Deleted Records
Indicates that the table is preserving deleted records in one of two ways. The first method is to use the user column (expanded) update type, where deleted records are left in the table after setting the update type to DELETE (2). The second method, adds the user column deleted_record and optionally the column delete_seqno, where a delete puts the current date/time into the deleted_record column and a sequence number to prevent duplicate records that occur when the record is deleted, reinserted, and deleted again within the same second. This can happen with applications that update by deleting and reinserting records.
Table Contains Only Keys
This indicates the all the columns in the table are keys.
Table has OCCURS DEPENDING ON
Indicates that the table is an occurs table that is derived from an item with an OCCURS DEPENDING ON clause. Such tables need special processing, as the number of occurrences can change, and we only store as many occurrences as the item in the OCCURS DEPENDING ON clause specifies.
Table Renamed by User
Indicates that the table_name column in the corresponding DATATABLES entry was modified. When a table is renamed, the table_name columns of its data items in the DATAITEMS table are also renamed.
Table Split
Indicates that this table is part of a split, where the item in the data set ends up in multiple tables because the table has too may columns, or, the user decided to split the table.