FIELDSHIFT command
Concept Information
Shifts the start position of a field definition in a table layout.
Syntax
FIELDSHIFT START starting_position COLUMNS bytes_to_shift <FILTER data_filter_name> <OK>
Parameters
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| START starting_position |
The starting byte position of the first field definition you want to shift. All field definitions to the right of the specified field definition are also shifted. If you specify a non-starting byte position, the next starting byte position is used. Note
For Unicode data, typically you should specify an odd-numbered starting byte position. Specifying an even-numbered starting position can cause characters to display incorrectly. |
||||||
| COLUMNS bytes_to_shift |
The number of bytes to shift the field definition. Enter a positive number to shift a field definition to the right. Enter a negative number to shift a field definition to the left. Note
For Unicode data, specify an even number of bytes only. Specifying an odd number of bytes can cause characters to display incorrectly. |
||||||
| FILTER data_filter_name optional |
The name of the filter that identifies field definitions associated with a particular record definition. |
||||||
|
OK optional |
Deletes or overwrites items without asking you to confirm the action. |
Examples
Shifting field definitions
You shift the field definition starting at byte 11, and any subsequent field definitions, 4 bytes to the right:
FIELDSHIFT START 11 COLUMNS 4
Remarks
For more information about how this command works, see Shifting fields in table layouts.
Shifted field definitions must remain within the record length
When you shift one or more field definitions right or left, the fields cannot exceed the record length in either direction.
Keep in mind that FIELDSHIFT moves both the specified field definition, and any field definitions to the right of the specified definition. If the shifted block of definitions would exceed the record length in either direction, an error message appears and the command is not executed.
Tip
If the error message is appearing because you are exceeding the end of the record, try removing the final field definition to make room for the field definitions being shifted.
