Previous Topic

Next Topic

Book Contents

Book Index

INCLUDE / EXCLUDE Examples (CTM)

The following examples illustrate INCLUDE / EXCLUDE logic. For all but the last example, assume the following expressions, all of which evaluate to True.

Table 324 Expressions for INCLUDE / EXCLUDE Examples

Expression

Evaluates To:

Key1=Value1

True

Key2=Value2

True

Key3=Value3

True

(CTM) Example 1

Select all records that match these expressions:

INCLUDE Key1=Value1,Key2=Value2,Key3=Value3

(CTM) Example 2

Select all records that match these expressions, using another method:

INCLUDE Key1=Value1

EXCLUDE Key2ØValue2

EXCLUDE Key3ØValue3

(CTM) Example 3

Select all records that match the first expression and either the second or third expressions:

INCLUDE Key1=Value1

EXCLUDE Key2ØValue2,Key3ØValue3

(CTM) Example 4

Select all records that do not match these expressions:

INCLUDE Key1ØValue1

INCLUDE Key2ØValue2

INCLUDE Key3ØValue3

(CTM) Example 5

Select all records that match either the second or third expression, but do not match the first expression:

INCLUDE Key2=Value2

EXCLUDE Key1=Value1

INCLUDE Key3=Value3

EXCLUDE Key1=Value1

(CTM) Example 6

The following example utilizes actual values (instead of the terms KeyN and ValueN).

Select the records of all volumes starting with FD whose data set name starts with BACKUP, except for those volumes starting with FD but ending with 102. Furthermore, independent of the preceding selection criteria, select records created by jobs whose job names start with CTT.

INCLUDE VOLSER=FD*,DSNAME=BACKUP*

EXCLUDE VOLSER=FD?102

INCLUDE CREJBN=CTT*

Parent Topic

Record Selection Logic (INCLUDE / EXCLUDE Statements) (CTM)