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


Chapter 15 Lists : list_names

list_names
The list_names table holds the names and definitions of all iProcess lists defined on the system.
Structure
The list_names table has the following structure:
TABLE list_names (
node_id
number(5) NOT NULL,
list_id number(5) NOT NULL,
list_name varchar2(15) NOT NULL,
list_type varchar2(1) NOT NULL,
list_length number(5) NOT NULL,
list_decimals number(5) NOT NULL)
List type: Either ASCII (A), Numeric (R), Date (D) or Time (T).
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.
Storage
The following STORAGE values are defined for this table.
Table Activity
The list_names table contains one row for each iProcess list 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 Lists data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_list_names table.
a Move System Information is performed, if the flag_table indicates that the Lists data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_list_names table.

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