 |
» |
|
|
|
SYSTEM.SECTION contains information about modules,
sections, and views. It initially contains the definitions of the
system views, and is updated
whenever ALLBASE/SQL processes a statement that creates, modifies,
or drops an object on which a section depends. You can use the following query on
this table to determine which sections are invalid:
isql=> SELECT OWNER, NAME, STYPE FROM System.Section
> WHERE Valid=0;
|
Table 8-30 System.Section | Column Name | Type | Length | Description |
|---|
| NAME | CHAR | 20 | Name of the module, procedure, or view | | OWNER | CHAR | 20 | Owner of the section or view | | DBEFILESET | CHAR | 20 | Name of the DBEFileSet containing the section or view | | SECTION | INTEGER | 4 | Section number: - 0
for views - 1 to n
for sections (numbers are sequentially assigned)
| | CTIME | CHAR | 16 | Time of creation: yyyymmddhhmmsstt | | TYPE | INTEGER | 2 | Type of SQL statement represented in the section: - 0
for sections that are neither views nor cursors - 1
for cursors - 2
for views
| | STYPE | INTEGER | 2 | Type of section: - 0
for module section - 1
for procedure section
| | VALID | INTEGER | 2 | Validity indicator: - 0
for view or invalid section - 1
for procedure
| | OPTFLAG | INTEGER | 2 | Setopt indicator: - 0
optimization plan not specified by SETOPT - 1
optimization plan specified by SETOPT
(See System.Setoptinfo) |
EXAMPLE | |
SELECT * FROM System.Section;
--------------------+--------------------+--------------------+-----------
NAME |OWNER |DBEFILESET |SECTION
--------------------+--------------------+--------------------+-----------
TABLE |SYSTEM |SYSTEM | 0
COLUMN |SYSTEM |SYSTEM | 0
INDEX |SYSTEM |SYSTEM | 0
SECTION |SYSTEM |SYSTEM | 0
DBEFILESET |SYSTEM |SYSTEM | 0
DBEFILE |SYSTEM |SYSTEM | 0
SPECAUTH |SYSTEM |SYSTEM | 0
TABAUTH |SYSTEM |SYSTEM | 0
COLAUTH |SYSTEM |SYSTEM | 0
MODAUTH |SYSTEM |SYSTEM | 0
GROUP |SYSTEM |SYSTEM | 0
PARTINFO |PURCHDB |SYSTEM | 0
VENDORSTATISTICS |PURCHDB |SYSTEM | 0
CEXP06 |JOHN |SYSTEM | 1
CEXP06 |JOHN |SYSTEM | 2
CEXP06 |JOHN |SYSTEM | 3
--------------------------------------------------------------------------
First 16 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
+----------------+------+------+------
|CTIME |TYPE |STYPE |VALID
+----------------+------+------+------
|1985090614181790| 2| 0| 0
|1985090614182250| 2| 0| 0
|1985090614182800| 2| 0| 0
|1985090614183320| 2| 0| 0
|1985090614183950| 2| 0| 0
|1985090614184680| 2| 0| 0
|1985090614185320| 2| 0| 0
|1985090614190000| 2| 0| 0
|1985090614190470| 2| 0| 0
|1985090614191190| 2| 0| 0
|1985090614191690| 2| 0| 0
|1985100915341710| 2| 0| 0
|1985100915342620| 2| 0| 0
|1985101211291030| 0| 0| 0
|1985101211291510| 0| 0| 0
|1985101211292020| 0| 0| 0
-----------------------------------------
First 16 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
