Types of access Schema DDL
86 U929-J-Z125-9-76
If LOCATION MODE IS DIRECT-LONG is specified, item-name must be defined as a
DATABASE-KEY-LONG item.
record-name specifies the record type containing the database key item referred to
by item-name.
identifier specifies the name of an item which is automatically generated by UDS/SQL for
storing database key values. This item serves as a key item, but is not part of a record type.
If you specify LOCATION MODE IS DIRECT, UDS/SQL generates the identifier item as a
DATABASE-KEY item.
If you specify LOCATION MODE IS DIRECT-LONG, UDS/SQL generates the identifier item
as a DATABASE-KEY-LONG item.
When entering a record, the database programmer can store a da tabase key value signi-
fying the position of the record within the record sequence in the item referred to by
item-name or identifier (see the section “DBTT (Database Key Translation Table)” on
page 131).
If the specified database key has already been assigned, another databa se key that is not
in use is automatically assigned by UDS/SQL.
If the database programmer does not wish to assign the database key value independently,
0 may be entered instead. This resumes the automatic assignm ent of database key values
by UDS/SQL.