EXCLUDE

The EXCLUDE primary command excludes from display certain records in the data being edited.
Read syntax diagramSkip visual syntax diagram
Syntax

>>-+-EXclude-+--+-+-+-----+--string-+--+---------------+-+------>
   '-X-------'  | | '-ALL-'         |  '-col1-+------+-' |   
                | '-string--ALL-----'         '-col2-'   |   
                '-+-----+--------------------------------'   
                  '-ALL-'                                    

>--+----------------+------------------------------------------><
   '-label1--label2-'   

Parameters
ALL
Causes the search to begin at the top of the data and find all occurrences of string. If not specified, the search begins at the cursor location (if the cursor is within the data portion of the screen) or the beginning of the first record displayed, and searches ahead to find the next occurrence of string in a record that is not already excluded.
Note:
  1. The command EXCLUDE ALL excludes all displayed records.
col1
The first column to be included in the range of columns to be searched. Must be greater than or equal to 1, and less than or equal to the maximum record length.
col2
The last column to be included in the range of columns to be searched. Must be greater than or equal to col1 and less than or equal to the maximum record length. If not specified, the last column of the record is used.
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.
string
The search string you want to search for. Records containing this string, within the limits imposed by the other EXCLUDE command parameters, are excluded. The string can be:
  • A character string not starting or ending with a quotation mark and not containing any embedded blanks or commas. The case of the string is ignored. Uppercase and lowercase representations of the same character match. For example, Mixed matches MIXED.
  • A character string enclosed in quotation marks. The string can contain blanks and commas. The case of the string is ignored. For example, 'Exact string' matches 'exact string'.
  • C followed by a character string enclosed in quotation marks (C'Frog'), or a character string enclosed in quotation marks followed by C ('Frog'C). The string can contain blanks and commas. The string must match exactly (including case). For example, C'Exact string' does not match C'exact string'.
  • X followed by a hexadecimal string enclosed in quotation marks (X'C1C2'), or a hexadecimal string enclosed in quotation marks followed by X ('C1C2'X).