This shows you the differences between two versions of the page.
|
dev:sql:statements:qualify:home [2010/07/04 16:22] tdo |
dev:sql:statements:qualify:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex SQL: QUALIFY ====== | ||
| - | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | ===== Description ===== | ||
| - | 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. | ||
| - | ===== Syntax ===== | ||
| - | QUALIFY [(owner-table_spec)] table_spec WHERE [AND | NOT | AND NOT] predicate | ||
| - | [ON [CURSOR] cursor] | ||
| - | [WITH options] | ||
| - | ===== Discussion ===== | ||
| - | ==== [(owner_table_spec)] table_spec ==== | ||
| - | Required. The owner_table is optional. The table parameter is the table from which to qualify rows. | ||
| - | |||
| - | ==== WHERE [AND | NOT | AND NOT] predicate ==== | ||
| - | 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. | ||
| - | ==== ON [CURSOR] cursor ==== | ||
| - | Optional - Specify which cursor to perform this command on. | ||
| - | ==== [WITH options] ==== | ||
| - | Optional - Specify options to be used for this command. | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||