Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Structure of records and tables Table structure
U929-J-Z125-9-76 225
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 12:03.14 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k08
Explanation of figure 58:
The length of the entries for the record sequence number (RSQ) and page index depend
on the page length that was defined for the database:
In tables of a database with a 2048-byte page length, the RSQ entry is 3 bytes long,
and the page index entry is 8 bytes.
In tables of a database with a 4000-byte or 8096-byte page length, the RSQ entry is
6 bytes long, and the page index entry is 12 bytes.
Pointer arrays, lists, sort key tables and standard SEARCH key tables are structured
according to the principle shown in figure 58. (The representation of the table line does not
apply to duplicates tables.) They are always stored in data pages. If a table does not fill a
page completely, the remaining space can be used for records or further tables. The table
headers contain the space reservations specified in the POPULATION clauses. This repre-
sents the third level of the three-level UDS/SQL Free Place Administration facility.
Furthermore, the table header contains pointers to other table parts if the table exceeds one
page and a pointer to the next higher table level if the page belongs to a lower level. Two
further indicators show the table level of the page itself and the type of the table.
1) follows the last table line in the case of lists.
2) bit 2
7
=1: list
2
6
=1: multi-level table
2
5
=1: table ATTACHED TO OWNER
2
4
=1: duplicates table
3) does not apply to duplicates tables (see figure 60 and figure 61).
4) applies to the highest table page of a multi-level table or to the first table page of a
single-level table only.