Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Reference section Schema DDL
U929-J-Z125-9-76 239
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.52 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k09
A maximum of 253 record types may be defined in a database with a page length
of 2048 bytes, and
a maximum of 32 766 record types may be defined in databases with a page length
of 4000 or 8096 bytes.
The individual clauses of the record entry are explained below.
RECORD NAME IS record-name
A name is assigned to a record type.
IN ⎫⎫
⎧DIRECT ⎫ item-name-1 record-name
⎨ ⎬ ⎨ OF ⎬
⎩DIRECT-LONG⎭  
[LOCATION MODE IS identifier ⎭⎬]
CALC[ has h-routine] USING item-name-2, ...
DUPLICATES ARE[ NOT] ALLOWED
item-name-1
must designate a database key item.
If you specify LOCATION MODE IS DIRECT, you must define item-name-1 as a
DATABASE-KEY item.
If you specify LOCATION MODE IS DIRECT-LONG, you must define
item-name-1 as a DATABASE-KEY-LONG item.
item-name-2
must specify an item of fixed length belonging to the record type.
You use LOCATION MODE IS DIRECT/DIRECT-LONG to enable you to assign the
database key of a record which is to be saved and to specify the sequence for sequential
processing.
You use LOCATION MODE IS CALC to specify a primary key to permit direct access to a
particular record or to a set of records with the same key values.
i