CE (Change Error) primary command

The CE (Change Error) primary command allows you to change numeric fields flagged as being in error (all asterisks in the field display) to a specific numeric value.

The find argument for the CE command is assumed to be a numeric field in error.

The CE command is only valid in SNGL or TABL display formats, when in edit or view.

For details on limiting the columns, fields or records searched by the CE command, see Limiting the effect of editing changes.

Syntax

Read syntax diagramSkip visual syntax diagram
                   .-NEXT--.                               
>>-CE--+--------+--+-ALL---+--+----------------+--+----+-------->
       +-string-+  +-FIRST-+  '-label1--label2-'  +-X--+   
       '-*------'  +-LAST--+                      +-EX-+   
                   '-PREV--'                      '-NX-'   

>--+-----+-----------------------------------------------------><
   '-ref-'   

string
A numeric value used to replace the invalid numeric value.
* (asterisk)
When used in place of the replacement string, uses the replacement string specified on the previous CE or CHANGE command as the replacement string. CE with no parameters, following a CE or CHANGE with a replacement string, acts the same as CE *.
ALL
Searches forwards from the top of data. Same as FIRST except that ALL also displays the total number of invalid numeric fields in the records searched.
Note: Suppressed or not-selected records that are hidden from display or represented by shadow lines are not searched, even when you specify ALL.
FIRST
Searches from the top of data for the first occurrence of an invalid numeric field.
LAST
Searches backwards from the bottom of the data for the last occurrence of an invalid numeric field.
NEXT
Searches forwards from the cursor position (if the cursor is within the data portion of the screen), or from the beginning of the topmost record displayed on the screen, for the next occurrence of an invalid numeric field.

If the next occurrence of the string is in an excluded record and you do not limit the search to not-excluded records, only the first excluded record containing the string is shown.

PREV
Searches backwards from the cursor position (if the cursor is within the data portion of the screen), or from the beginning of the topmost record displayed on the screen, for the next occurrence of an invalid numeric field.
label1
Label identifying the start of a range of records. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.
label2
Label identifying the end of a range of records. The label must start with a period (.) followed by one to four alphabetic characters (no numeric or special characters). Labels starting with the letter “Z” indicate an editor-assigned label.
EX
Excluded records only.
NX
Not-excluded records only.
X
Same as EX.
ref
A field reference, specifying the field to be included in the search. For example: #3.

Availability