Справочник Пользователя для Fujitsu UDS/SQL V2.5
Schema DDL
Reference section
240
U929-J-Z125-9-76
WITHIN realm-name-1[,realm-name-2,... AREA-ID IS identifier]
realm-name-1,-2,...
must not be temporary realms.
The records of the record type are allocated to certain realms.
⎧CALC[ hash-routine]⎫
[SEARCH KEY IS item-name,... USING
⎨ ⎬[ NAME IS name]
⎩INDEX ⎭
DUPLICATES ARE[ NOT] ALLOWED]....
item-name
specifies an item of fixed length belonging to the record type.
name
specifies tables for SEARCH keys; referred to in the SSL statements.
Additional direct access paths via secondary key are specified and a name is assigned to
the SEARCH KEY table or the hash area, which can be referenced in the SSL.
the SEARCH KEY table or the hash area, which can be referenced in the SSL.
[level-number ]record-element-name
level-number
must be an integer between 1 and 99.
Default value: 1
Default value: 1
A name is assigned to a record element and optionally a level number can be defined.
The total length of all record elements of one record type must not exceed the
maximum record length.
The maximum record length is equal to:
The maximum record length is equal to:
–
2020 bytes in a database with a page length of 2048 bytes (2-Kbyte format)
–
3968 bytes in a database with a page length of 4000 bytes (4-Kbyte format)
–
8064 bytes in a database with a page length of 8096 bytes (8-Kbyte format)
Depending on the length of the SCD, the maximum record length may also be
somewhat lower.
somewhat lower.
i