Schema DDL Types of access
U929-J-Z125-9-76 103
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k04
4.7.5 Determining set occurrence selection SET OCCURRENCE SELECTION IS THRU
⎧CURRENT OF SET ⎫
⎧item-name ⎫
LOCATION MODE OF OWNER[ ALIAS FOR ⎨ ⎬ IS identifier-2]...
⎩ ⎩identifier-1⎭ ⎭
When accessing records via sets, it is first necessary to select the desired set occurrences.
Two selection options are available:
SET OCCURRENCE SELECTION IS THRU CURRENT OF SET
In this case, the record last referenced within a set (CRS) identifies the se t occurrence.
SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER
[ALIAS FOR item-name / identifier-1 IS identifier-2]...
⎧item-name ⎫
[ALIAS FOR ⎨ ⎬ IS identifier-2]...
⎩identifier-1⎭
This option requires you to have defined a unique primary key for the owner record type wi th
one of the following clauses:
– LOCATION MODE IS DIRECT or LOCATION MODE IS DIRECT-LONG
– LOCATION MODE IS CALC..... DUPLICATES ARE NOT ALLOWED
This key is either the database key or a CALC key.
UDS/SQL can use this option either to read a record from a set occurrence (see th e manual
“Application Programming”, FIND 7) or to insert a new record into a set occurrence (see
STORE and MODIFY in the “Application Programming” manual). All the programmer has to
do is provide UDS/SQL with the key value uniquely identifying the owner record of the set
occurrence. UDS/SQL will automatically select the set occurr ence on owner record type
level using direct access via the database key or the hash routine, and make the selected
owner record the CRS.