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 cer tain 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.
[level-number ]record-element-name
level-number
must be an integer between 1 and 99.
Default value: 1
A name is assigned to a record element and optionally a level number can be de fined.
The total lengt h of all record elements of one record type must not exceed the
maximum record length.
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.
i