Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 11 Administrative Tables : flag_table

flag_table
The flag_table table provides a locking mechanism which controls access to the four areas of iProcess administrative data - users, lists, roles and TIBCO iProcess Engine tables. iProcess administrative data is maintained in two sets of tables:
The flag_table table contains a row for each area of iProcess administrative data, and is used to prevent multiple users from editing the same data at the same time.
When a user edits the data in a particular row (for example, using User Manager to edit user data), the area_locked flag is set while editing takes place. On completion of the edit, the area_locked flag is cleared. If changes have been made, the area_changed flag is set.
When a user requests a Move System Information, the move_req flag is set on any rows that have the area_changed flag set. When the background process sees a row with move_req flagged that is not locked, it locks the area and updates the main system data tables from the tsys_ tables. When the Move System Information operation completes, all the flags are cleared.
Structure
The flag_table table has the following structure:
TABLE flag_table (
area_id INTEGER NOT NULL,
area_locked INTEGER NOT NULL,
area_changed INTEGER NOT NULL,
move_req INTEGER NOT NULL,
user_name VARCHAR(64) )
Unique ID of this area of iProcess administrative data: Either Users (1), iProcess Tables (2), Lists (3) or Roles (4).
Flag that defines whether (1) or not (0) the specified area_id is locked. The flag is set by:
Flag that defines whether (1) or not (0) the tsys_ tables for the specified area_id contain modified data.
Flag that defines whether (1) or not (0) the specified area_id needs to be updated by a Move System Information operation.
swpro if the background process has the area locked.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Table Activity
The flag_table table always contains 4 rows - one row for each area of iProcess administrative data (users, lists, roles and TIBCO iProcess Engine tables).
The table is populated when the iProcess Engine is installed.
Rows are added, updated and deleted in the following situations.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved