Expressions › Expression

Expression

   ┌─ c ───────────────────────────────┐
►►─▼─┬─────┬─┬─ function ────────────┬─┴──────────────────────────────────────►◄
     ├─ - ─┤ ├─ (expression) ────────┤
     └─ + ─┘ ├─ CASE expression ─────┤
             ├─ COALESCE expression ─┤
             ├─ NULLIF expression ───┤
             ├─ CAST expression ─────┤
             ├─ literal ─────────────┤
             ├─ column-name ─────────┤
             ├─ host-variable ───────┤
             ├─ special-register ────┤
             ├─ labeled-duration ────┤
             ├─ SQL-parameter ───────┤
             └─ SQL-variable ────────┘

Expansion of c

├──┬─ * ─┬────────────────────────────────────────────────────────────────────┤
   ├─ \ ─┤
   ├─ - ─┤
   └─ + ─┘

Notes:

• The special-register is a CA Datacom/DB extension. See Special Registers.
• The labeled-duration is a CA Datacom/DB extension. See Labeled Duration.
• For information on SQL-parameter, see the CA Datacom/DB SQL User Guide.
• For information on SQL-variable, see the CA Datacom/DB SQL User Guide.