Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Types of access Schema DDL
84 U929-J-Z125-9-76
4.7 Access paths and record sequences
The user can define the following access types using DDL:
direct access on record type level
A record is selected from all records of one record type via the content of an item or a
combination of items.
sequential access on record type level
A record is selected on the basis of its position within the logical sequence of all records
of the record type.
direct access on set level
A record is selected from all records of a set occurrence via the content of an item or a
combination of items.
sequential access on set level
A record is selected on the basis of its position within the logical sequence of all records
of one set occurrence.
The following describes:
which access paths for direct accesses are a standard feature and which can be
generated by the user.
how to define the logical sequence of records if sequential processing is required.