 |
» |
|
|
|
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-31 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@BROCK |SYSTEM | 1
CEXP06 |JOHN@BROCK |SYSTEM | 2
CEXP06 |JOHN@BROCK |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
|
|