Previous Topic: EXISTS PredicateNext Topic: NULL Predicate


IN Predicate

►►─ expression ─┬───────┬─ IN ─┬─ (subselect) ──────────────────────┬─────────►◄
                └─ NOT ─┘      │     ┌─ , ────────────────────┐     │
                               └─ ( ─▼─┬─ host-variable ────┬─┴─ ) ─┘
                                       ├─ literal ──────────┤
                                       └─ special-register ─┘

The special-register is a CA Datacom/DB extension. See Special Registers.