Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Schema DDL Reference section
236 U929-J-Z125-9-76
9.1 Schema DDL syntax
SCHEMA NAME clause
Schema entry
[PRIVACY LOCK clause].
AREA NAME clause
Realm entry
[TEMPORARY clause].
RECORD NAME clause
[LOCATION MODE clause]
WITHIN clause
[SEARCH KEY clause].
Record entry
record element name clause
[PICTURE clause]
[TYPE clause]
[OCCURS clause].
SET NAME clause
[DYNAMIC clause]
ORDER clause
OWNER clause.
Set entry
[MEMBER clause
[ASCENDING/DESCENDING-KEY clause]
[SEARCH KEY clause]
[SET OCCURRENCE SELECTION clause]].
Figure 62: Structure of schema DDL
The description of the logical data structure should always be started with the schema entry
and at least one realm entry.
The following applies for the subsequent realm, record and set entries:
The two associated record types must be defined before a set can be defined.
All the realms mentioned in the WITHIN clause for the record must be defined before a
record type can be defined.