WHERE clause processing
For more information, see BMC-AMI-Utilities-SQL-language.
DO_WHERE and SKIP_WHERE functions
BMC AMI Utility Manager provides two functions for working with WHERE clauses: DO_WHERE and SKIP_WHERE.
You can use these functions instead of using G.NEEDS_REORG or using AND NOT.
DO_WHERE
DO_WHERE(A.NACTIVE < 540 AND EXTENTS > 1)
SKIP_WHERE
SKIP_WHERE(A.NACTIVE < 8)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*