Fujitsu UDS/SQL V2.5 用户手册
OWNER clause and SEARCH KEY clause
Schema DDL
106
U929-J-Z125-9-76
hash-routine
denotes the name of a module converting the secondary key to a 4-byte binary
number. This binary number is subsequently converted into a relative page number by
UDS/SQL. The corresponding page contains the pointer to the record (see
UDS/SQL. The corresponding page contains the pointer to the record (see
If hash-routine is omitted, UDS/SQL uses the same standard hash routine as for conversion
of the primary key on record type level (for programming a hash routine as well as using the
standard hash routine, see
of the primary key on record type level (for programming a hash routine as well as using the
standard hash routine, see
).
More than one secondary key may be defined.
4.8.2
Dynamic set
In general, DML statements process one record of the database at a time.
One particular DML retrieval statement, however, selects several records from the database
at the same time (see the “
One particular DML retrieval statement, however, selects several records from the database
at the same time (see the “
“ manual, FIND 7). The selected
records are buffered for further processing. UDS/SQL does this by automatically making the
records member records in a dynamic set.
records member records in a dynamic set.
It is characteristic of a dynamic set that, during a transaction, it can accept records of
various record types, identifying them as intermediate results of a search query, and discard
them when the intermediate result is no longer required. Membership in a dynamic set is
thus of the OPTIONAL MANUAL type and there is no defined member record type.
various record types, identifying them as intermediate results of a search query, and discard
them when the intermediate result is no longer required. Membership in a dynamic set is
thus of the OPTIONAL MANUAL type and there is no defined member record type.
One set occurrence is sufficient for storing selected records in a dynamic set as connection
data relating to certain owner records need not be stored, i.e. a dynamic set is declared as
SYSTEM set.
data relating to certain owner records need not be stored, i.e. a dynamic set is declared as
SYSTEM set.
The set is called dynamic because it holds member records for the course of one trans-
action only. There is no static set membership.
action only. There is no static set membership.
In order to be able to define a dynamic set, the user must include a temporary realm in the
schema. The dynamic set is defined as follows:
schema. The dynamic set is defined as follows:
SET NAME IS set-name
SET IS DYNAMIC
ORDER IS IMMATERIAL
OWNER IS SYSTEM.
SET IS DYNAMIC
ORDER IS IMMATERIAL
OWNER IS SYSTEM.
If the Interactive Query Language IQL is to be used, the user must define eight dynamic
sets with the names IQL-DYN1 through IQL-DYN8. More details can be found in the manual
“
sets with the names IQL-DYN1 through IQL-DYN8. More details can be found in the manual
“