Modifying Schema Entities › Record Modifications › Changing Other Record Characteristics

Changing Other Record Characteristics

Types of Changes

You can make the following changes to the characteristics of a record (changes other than those described previously in this chapter):

• Record ID
• Record synonyms
• VSAM type
• Minimum root and minimum fragment length
• Whether the record is compressed or uncompressed

Note: For information about dropping or adding a database procedure associated with a record, see 33.5.9, “Adding and Dropping Database Procedures”.

What components are affected

The record definition is affected and the data is affected if changing the record ID or compression. All subschemas and access modules that reference the record are affected. SQL views are affected only if the SQL synonym for an element is changed.

Steps to make the change

To modify the VSAM type, record synonyms, or minimum root and fragment lengths, follow the procedure described in Modifications to an Unloaded Database at the beginning of this chapter.

Considerations

• To change the record ID when data exists, write a program that offloads and reloads that data.
• Optionally, unload and reload the data to reorganize existing data after changing the minimum root or minimum fragment.
• To change a record from compressed to uncompressed, you must either unload and reload the data or use RESTRUCTURE to alter the data.
• If changes to the record elements do not affect control fields, all you need to do is issue a DDDL MODIFY RECORD statement.

  Note: For more information about modifying non-IDD owned records, see the CA IDMS IDD DDDL Reference Guide.

• If you change the SQL synonym for one or more elements, then you must drop and recreate all SQL views that reference the record. You must also change all programs that refer to those elements in an SQL statement.
• If you change the VSAM type, ensure that appropriate changes, if necessary, are made to the VSAM definition using the IDCAMS utility.