This is an old revision of the document!
The Omnidex QUALIFY statement is an advanced statement used for testing and for legacy applications requiring access to Omnidex pre-intersect counts. The use of the QUALIFY statement has been replaced by adding features to the SELECT statement.
QUALIFY [(owner-table_spec)] table_spec WHERE [AND | NOT | AND NOT] predicate
[ON [CURSOR] cursor]
[WITH options]
Required. The owner_table is optional. The table parameter is the table from which to qualify rows.
Required. Criteria used to qualify rows. A SAMELIST operator (AND, NOT, or AND NOT) can precede the column/criteria pair. The SAMELIST operator is not used on the first qualify statement.
Optional - Specify which cursor to perform this command on.
Optional - Specify options to be used for this command.