Skip to content

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 presented as Basic, Relational Info, and Options.

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 index_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.