Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Schema DDL modifications

Schema entry

No restrictions

Realm entry

Conversion of a temporary realm into a non-temporary realm or vice versa is not allowed.

Record entry

WITHIN clause

If a realm is omitted in the WITHIN clause, no records of the record type concerned may be stored in this realm except in the case of distributable lists.

Record length

Record types which are members in a single-level list must not be lengthened.

Set entry

DYNAMIC clause

Conversion of a set into a dynamic set and vice versa is not allowed.

ORDER clause

If records of the member record type of the set to be modified have been stored, the following restrictions must be observed:

  • for ORDER IS SORTED[ INDEXED] and MODE IS POINTER-ARRAY/LIST the ORDER clause must not be changed to ORDER IS LAST, FIRST, NEXT, PRIOR or IMMATERIAL;

  • for any ORDER clause and MODE IS CHAIN, the ORDER clause can only be changed to ORDER IS LAST, FIRST, NEXT, PRIOR or IMMATERIAL if, in so doing, the SCD of the owner record type or of the member record type is not lengthened;

  • for ORDER IS LAST, FIRST, NEXT, PRIOR or IMMATERIAL and MODE IS LIST, the ORDER clause can only be changed to ORDER IS LAST, FIRST, NEXT, PRIOR or IMMATERIAL if, in so doing, the member record type including SCD is not lengthened.

OWNER clause

The OWNER clause of a set must not be modified. 

MEMBER clause

record-name:
Specifying a new member record type is not allowed.

set membership

  • If an existing set is modified and if records of the member record type are stored in the database, set membership must not be converted from OPTIONAL to MANDATORY AUTOMATIC if certain member records stored are not allocated to an owner.

  • If a new set is defined and if records of the member record type are stored in the database, AUTOMATIC must not be defined as set membership, except for SYSTEM sets.