Examples
The following example shows a TS_REORG_WHERE clause:
DO_WHERE (A.NACTIVE < 540 AND A.EXTENTS > 1)
In the next example, if the WHERE clause is true, BMC AMI Utility Manager reorganizes selected objects unless they have fewer than eight active pages. The example uses the WHERE clause only to exclude objects.
SKIP_WHERE (A.NACTIVE < 8)
The next example combines the WHERE clauses from the previous examples, selecting small objects that are in extents and excluding very small objects:
DO_WHERE(A.NACTIVE < 540 AND A.EXTENTS > 1)
OR SKIP_WHERE(A.NACTIVE < 8)