Table structure Structure of records and tables
226 U929-J-Z125-9-76
The following overview shows which of the three available table lines corresponds to which table type:
DDL/SSL clauses Table type Content of a table line:
Name of the
table
lowest level higher level
MODE IS
POINTER-ARRAY
ORDER IS LAST/
FIRST/NEXT/PRIOR
single-level RSQ, PPP - single-level
pointer array
MODE IS
POINTER-ARRAY
ORDER IS
SORTED INDEXED
BY DATABASE-KEY
multi-level RSQ, PPP RSQ, act-key
multi-level
pointer array
MODE IS
POINTER-ARRAY
ORDER IS
SORTED INDEXED
BY DEFINED KEYS
ASCENDING/
DESCENDING KEY IS...
multi-level
key value,
RSQ, PPP
key value,
RSQ, act-key
MODE IS LIST
ORDER IS LAST/
FIRST/NEXT/PRIOR
single-level member record -
single-level list
MODE IS LIST
ORDER IS
SORTED INDEXED
BY DATABASE-KEY
multi-level member record RSQ, act-key
multi-level
pointer array
MODE IS LIST
ORDER IS
SORTED INDEXED
BY DEFINED KEYS
ASCENDING/
DESCENDING KEY IS...
multi-level member record key value,
RSQ, act-key
Table 21:Overview of the table types (part 1 of 2)