Effect of ADD on Sets
ADD copies the set description from the schema description into the subschema description.
Before a set can be added to the subschema, the record that owns that set must be present in the subschema. Note, however, that system-owned indexed sets and sets based on native VSAM data sets) are excluded from this rule, since the owner record is not specified in the subschema.
For a set to be a valid subschema component, at least one member record must be present in the subschema.
Note: For information about validation, see 14.8, “VALIDATE Statement".
Effect of MODIFY on Sets
MODIFY modifies some aspect of the set's participation in the subschema. All clauses associated with an ADD operation can be specified for MODIFY operations.
Effect of DELETE on Sets
DELETE removes the set from the current subschema description in the dictionary; the set remains associated with the schema.
Set Automatically Deleted When Owner Record Deleted
If the set's owner record is deleted, either from the schema or from the subschema, the set is automatically deleted from the subschema.
Explicitly Delete Set After Deleting Member Records
If the set's member record is deleted, either from the schema or from the subschema, the set remains in the subschema. To delete the set, delete all the member records associated with the set before issuing the DELETE SET statement.
|
Copyright © 2014 CA.
All rights reserved.
|
|