Changing data types

A System Administrator can change the type of a scalar field. For example, from a character field to a number field.

If no data exists in the file, you can edit the field and change the field type quickly without any other modification required.

If data exists in the file, you must first change the type of the field in the database dictionary record, and then convert the existing data in the modified field to be consistent with the new field type. This must be done for all records in the file that contain data in the modified field.

Related topics

Arrayed structures
Alias fields
Methods for updating database dictionary records
Methods for deleting database dictionary records
Adding a key
Modifying a key
Deleting a key

Modify field types: Single to concatenated
Modify field types: Character (scalar) to array
Change data types: Character to number
Remove a field from an existing database dictionary record