Filter
Top Products
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\uds\Manuale\en\udsent_e\udsent.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 set 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 with
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 the 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 occurrence on owner record type
level using direct access via the database key or the hash routine, and make the selected
owner record the CRS.