LOGSCAN search condition definition
A search condition can contain a simple filter predicate, multiple filter predicates, or a combination of filter predicates and additional search conditions. Use standard SQL syntax to combine multiple filter predicates and search conditions.
The following figure shows the Search condition definition syntax used in the WHERE clause of the LOGSCAN statement.
| Option | Description |
|---|---|
| Filter predicate | A simple filter predicate defines one condition that will control log scan output. For more information, see Filter predicate. |
| Search condition definition | Search conditions can include additional, nested search conditions. All nested search conditions must conform to the syntax rules defined in this section. |
| AND | OR | NOT | Use the AND keyword, the OR keyword, or the NOT keyword to join multiple search conditions or filter predicates. These keywords work the same as logical operators in standard SQL syntax. |
This section contains the following topics:
- Filter predicate
- Selectable field definition
- Catalog activity definition
- Catalog object definition
- Synonyms
- Db2 command definition
Comments
Log in or register to comment.