EXCLUDE

eXclude   [ NEXt | PREv | FIRst | LASt ] 
   [ IN column ] [ ALL ]
   { [CHAr] char | HEX hex | NUMber num | 
     FLOat float | NULl } [ flag ] 

NEXT

Specifies that the search is to proceed forward from the current location. This is the default.

PREV

Specifies that the search is to proceed backward from the current location.

FIRST

Specifies that the search is to begin with the first row of data.

LAST

Specifies that the search is to begin with the last row of data and proceed backward.

IN column

Identifies the name of the column to search. If not specified, all columns in the table in which the cursor is positioned with the same data type as the search argument are searched. If the cursor is not positioned on a table, the columns in the lowest-level table are searched.

ALL

Specifies that the search is to begin with the first row of data and proceed forward to locate and exclude all occurrences. If not specified, only the first occurrence is excluded. If specified with no other parameters, all rows are excluded.

CHAR char

Specifies a character data type as the search value. This includes CHAR, VARCHAR, LONG VARCHAR, GRAPHIC, VARGRAPHIC, BINARY, VARBINARY, DATE, TIME, and TIMESTAMP data types. It is the default data type and, therefore, the keyword CHAR is optional.

To specify a character string, use apostrophes to include embedded blanks or quotation marks in the string as in 'A B' or 'A" B'. Use quotation marks to include embedded blanks or apostrophes in the string as in A 'B. Use C to retain character case as in C'ABC' to search for the uppercase string ABC.

HEX hex

Specifies that the search value is the hexadecimal representation of character data.

For hex, the string must conform to the rules for hexadecimal values: contain an even number of characters and contain only the digits 0 through 9 and the alphabetic characters A through F.

NUMBER num

Specifies a numeric data type (SMALLINT, INTEGER, or DECIMAL) as the search value.

FLOAT float

Specifies a floating point data type as the search value.

NULL

Defines the search value as the NULL value regardless of the column data type.

flag

Provides an additional filter to the rows targeted by the EXCLUDE command during Compare processing only. The available filters include the original source and the nature of the encountered changes. Possible values are:

Source

S1

Source 1 rows exclusively.

S2

Source 2 rows exclusively.

S1*

Source 1 and common rows.

S2*

Source 2 and common rows.

S12

Common rows regardless of other flags.

S1Unmatched

Source 1 rows that do not match a Source 2 row.

S2Unmatched

Source 2 rows that do not match a Source 1 row.

UNMatched

Any rows in one source that do not have a match in the other source.

Change

Dir

Rows with Direct changes only.

Rel

Rows with Related changes only.

DR

Rows with Direct or Related changes.

CHG

Any change or any uncommon row. Alternate form: NCOM.

COMmon

Common rows that have no other flags set. Alternate form: NCHG.

Other

DUP

Rows with Duplicate match key values.

ORPhans

Orphan rows only. Alternate forms: ORPHANS or ORPHAN.

RKD

Rows that have a change in the columns that comprise the basis for a relationship to other tables.

UNUsual

Orphan rows, or rows that have a change in the columns that comprise the basis for a relationship to other tables.

Notes®

• A search value must be specified. When browsing a Compare File, a search value, a flag value, or both may be specified.
• The excluded rows are replaced by a one-line message indicating the location and number of excluded rows.
• When rows are excluded, the total number of displayed lines shown in the Information line is revised and each excluded lines message is included in the total count.
• To specify a keyword as a search value, use apostrophes, as in 'ALL' or 'IN'.
• The HEX operand can only be specified during hexadecimal display.
• The SHOW command can be used to redisplay excluded rows.
• The FIND, CHANGE and DELETE primary commands provide operands to specifically include or ignore excluded rows in processing.
• Use the ONLY command to locate and display only rows that satisfy the specified criteria.
• If only the column name is specified, and only one table contains that column, only that column is searched.
• The fully qualified column name should be specified when more than one table contains a column of the specified name. The column can be qualified by the table name, the view name, or the identifier (Tn or Vn).
• When more than one table contains the named column and a table name has not been specified, the lowest-level table containing the specified column is searched.

Expanded Data Display

• The EXCLUDE command can be specified during expanded data display; however, the IN column operand is not available. Only the currently expanded column is searched.