Fujitsu UDS/SQL V2.5 Manual Do Utilizador

Reference section

236

  

 U929-J-Z125-9-76

                   

⎧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.