Row Commands - X (Exclude)

The X row command excludes rows from display. Without a parameter, the X command excludes the specified row from the window.

image2021-5-8_17-59-16.png

The X command divides the rows currently displayed into two subsets which can be processed separately.

Another use of the X command is to remove objects from display before executing a command that affects displayed objects. For example, when the DR (drop) row command is executed on a range of rows, SQL is generated to drop all objects in the range. By excluding objects that you want to keep, SQL DROP statements are generated only for those that are displayed.

The SWITCH primary command toggles the window display between the two subsets. To unexclude the rows, enter the RESET primary command.

XX Block Format

Specifies a block of rows to exclude.

n

Specifies the number of rows to exclude.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*