 |
» |
|
|
|
SYSTEM.IMAGEKEY contains an entry for each IMAGE key on
each dataset in each IMAGE database attached to this DBE.
In ALLBASE/SQL terms the IMAGE keys are viewed as indexes, and the datasets on
which they are defined are viewed as tables. The IMAGE database in which these datasets reside is listed as the owner of these IMAGE tables. Table 8-16 System.Imagekey |
Column Name | Type | Length | Description |
|---|
| INDEXNAME | CHAR | 20 | Index name give to the IMAGE key | | TABLENAME | CHAR | 20 | Name of the table (dataset) on which the
IMAGE key is defined | | OWNER | CHAR | 20 | Owner of the table (dataset)
on which the IMAGE key is defined. This is always the
Name of the IMAGE database where the dataset is
stored. | | UNIQUE | SMALLINT | 2 | Uniqueness indicator:
- 0
if duplicates are allowed, that is, the index is not unique - 1
if duplicates are not allowed, that is the index is unique
| | NUMC | INTEGER | 4 | Number of columns in the IMAGE key (always 1 for
IMAGE keys) | | COLNUMS | BINARY | 64 | A vector of 16 SYSTEM.COLUMN entries,
each of type SMALLINT, identifying
the column numbers the IMAGE key is defined over | | NDISTINCT | INTEGER | 4 | Number of distinct values | | PRIMARIES | INTEGER | 4 | Number of primary slots used. (not currently
used) | | SCCCOUNT | INTEGER | 4 | Synonym chain cluster count; indicates the number
of page changes necessary to read through the
entire synonym chain. (not currently used) | | DCCCOUNT | INTEGER | 4 | Detail chain cluster count; indicates the average
number of page changes necessary to read through
a detail chain. (not currently used)
|
Example | |
SELECT * FROM System.Imagekey;
--------------------+--------------------+--------------------+------+-----
INDEXNAME |TABLENAME |OWNER |UNIQUE|NUMC
--------------------+--------------------+--------------------+------+-----
ALBUMCODE_M1 |ALBUMS |MUSIC | 1|
COMPOSERNAME_M1 |COMPOSERS |MUSIC | 1|
SELECTIONNAME_A1 |SELECTIONS_A |MUSIC | 1|
ALBUMCODE_D1 |SELECTIONS |MUSIC | 0|
SELECTIONNAME_D2 |SELECTIONS |MUSIC | 0|
COMPOSERNAME_D3 |SELECTIONS |MUSIC | 0|
ALBUMCODE_D1 |LOG |MUSIC | 0|
SELECTIONNAME_D2 |LOG |MUSIC | 0|
---------------------------------------------------------------------------
Number of rows selected is 8
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > r
-+--------------------+------+-----------+---------------------------------
|OWNER |UNIQUE|NUMC |COLNUMS
-+--------------------+------+-----------+---------------------------------
|MUSIC | 1| 1|000100000000000000000000000000000
|MUSIC | 1| 1|000100000000000000000000000000000
|MUSIC | 1| 1|000100000000000000000000000000000
|MUSIC | 0| 1|000100000000000000000000000000000
|MUSIC | 0| 1|000200000000000000000000000000000
|MUSIC | 0| 1|000300000000000000000000000000000
|MUSIC | 0| 1|000100000000000000000000000000000
|MUSIC | 0| 1|000200000000000000000000000000000
---------------------------------------------------------------------------
Number of rows selected is 8
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > r
-+----------------------------------------------------------------+--------
|COLNUMS |NDISTINC
-+----------------------------------------------------------------+--------
1|0001000000000000000000000000000000000000000000000000000000000000|
1|0001000000000000000000000000000000000000000000000000000000000000|
1|0001000000000000000000000000000000000000000000000000000000000000|
1|0001000000000000000000000000000000000000000000000000000000000000|
1|0002000000000000000000000000000000000000000000000000000000000000|
1|0003000000000000000000000000000000000000000000000000000000000000|
1|0001000000000000000000000000000000000000000000000000000000000000|
1|0002000000000000000000000000000000000000000000000000000000000000|
---------------------------------------------------------------------------
Number of rows selected is 8
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > r
--------------------------+-----------+-----------+-----------+-----------
|NDISTINCT |PRIMARIES |SCCCOUNT |DCCCOUNT
--------------------------+-----------+-----------+-----------+-----------
00000000000000000000000000| 3| 0| 0| 0
00000000000000000000000000| 7| 0| 0| 0
00000000000000000000000000| 9| 0| 0| 0
00000000000000000000000000| 3| 0| 0| 0
00000000000000000000000000| 9| 0| 0| 0
00000000000000000000000000| 7| 0| 0| 0
00000000000000000000000000| 3| 0| 0| 0
00000000000000000000000000| 9| 0| 0| 0
---------------------------------------------------------------------------
Number of rows selected is 8
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > e
|
|
