RENAME FIELD command

Summary

Privileges

File manager

Function

Changes the name of a field

Syntax

RENAME FIELD old-fieldname, new-fieldname

Where: old-fieldname and new-fieldname are field names (1 to 255 characters). When the command is executed, the new fieldname becomes the new name of the field.

Syntax notes

The comma is required.

Example

RENAME FIELD SOCIAL SECURITY, SSN

Usage notes

The RENAME FIELD command changes the name of a field. The command is rejected if the old field name does not exist or if the new field name cannot be added to the file, either because it already exists or because there is not enough space. RENAME FIELD can be used to rename Ordered Index fields.

When it processes RENAME FIELD, Model 204 ends any update unit in progress and begins a non-backoutable update unit. For more information about Model 204 update units, see the Model 204 File Manager's Guide.

The RENAME FIELD command is prohibited for the DTSFN field in a file when the FOPT=X'10' is set. Attempting to do so results in the following message

M204.2727: CANT DELETE DTS FIELD WHEN FOPT=X'10' IS ON