INCLUDE / EXCLUDE Block (CTM)

An INCLUDE / EXCLUDE block is composed of any number of INCLUDE statements followed by any number of its corresponding EXCLUDE statements.

The format of an INCLUDE / EXCLUDE block is

Figure 120 INCLUDE / EXCLUDE Statements

The relationship between multiple INCLUDE statements in a block is OR.

The relationship between multiple EXCLUDE statements in a block is OR.

The relationship between an INCLUDE statements and the following EXCLUDE statements in a block is AND.

Single INCLUDE / EXCLUDE Block Processing (CTM)

If even one EXCLUDE statement of a block is true (meaning, a record satisfies the EXCLUDE statement), the record is not selected and the next record is examined.

If all EXCLUDE statements in the block are false, the INCLUDE statement is evaluated against the record

• If the INCLUDE statement is true, the record is selected.
• If the INCLUDE statement is false, the record is not selected and the next record is examined.

Multiple INCLUDE / EXCLUDE Blocks (CTM)

Multiple INCLUDE / EXCLUDE blocks can be specified.

• If multiple INCLUDE / EXCLUDE blocks are specified, the relationship between the blocks is OR and the blocks are checked sequentially.
• If a record is not selected after being checked against an INCLUDE / EXCLUDE block, it is checked against the next INCLUDE / EXCLUDE block. Once a record is selected based on an INCLUDE / EXCLUDE block, the record is included and not checked against other blocks.
• If only EXCLUDE statements are specified in the first block (meaning, no INCLUDE statements are specified), only records not excluded by the first block are considered for selection by subsequent INCLUDE / EXCLUDE blocks.

  Figure 121 INCLUDE / EXCLUDE Blocks