Including segment sensitivity in a program view

The CREATE SENSEGVIEW clause is used to define a hierarchically related set of tables to a schema of a program view. This set represents tables to which a program through a schema is sensitive.

The table identified by this clause can physically exist in one database or can be derived from several physical databases. One or more of these clauses can be included for a schema and can only be specified within a CREATE SCHEMA clause.

There must be one senseg view for each table to which the application program is sensitive. All tables in the hierarchic path to any required table must be specified. A maximum of 30,000 senseg views can be defined in a single program view.

The order in which senseg views are sequenced in a schema determines the logical access order for the tables.