Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 14 TIBCO iProcess Tables : dbs_names

dbs_names
The dbs_names table holds the names of all installed TIBCO iProcess Engine tables.
Structure
The dbs_names table has the following structure:
TABLE dbs_names (
node_id
INTEGER NOT NULL,
dbs_id INTEGER NOT NULL,
dbs_name VARCHAR(15) NOT NULL)
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Table Activity
The dbs_names table contains one row for each installed TIBCO iProcess table on the system.
Rows are added, updated and deleted in the following situations.
a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_dbs_names table.
a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_dbs_names table.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.