A row of SYSTEM.SECTION describes part or all the tree form (the form input to the optimizer) of either a search condition that defines a check constraint or a SELECT statement that defines a view. If more than one row is needed to return the entire section, the order of the section portions is represented in column SEQUENCE.
View SYSCA.SECTION is defined on SYSTEM.SECTION.
Note: For more information, see SYSCA Objects.
|
Column name |
Column description |
Data type |
Null specifi- cation |
|---|---|---|---|
|
SCHEMA |
Schema-name qualifier of the table or view. |
CHAR(18) |
NOT NULL |
|
TABLE |
Table or view name. |
CHAR(18) |
NOT NULL |
|
TYPE |
Section type:
|
CHAR(1) |
NOT NULL |
|
FORMAT |
Section format; Value is I (I-tree) |
CHAR(1) |
NOT NULL |
|
SEQUENCE |
Sequence number of this portion of the section. |
SMALLINT |
NOT NULL |
|
TEXT |
Text of the section representing the check constraint or view definition. |
BINARY(512) |
NOT NULL |
|
Copyright © 2014 CA.
All rights reserved.
|
|