Scalar Functions

Scalar functions are a CA Datacom/DB extension. A scalar function produces a single value from another value. It is expressed in the form of a function name, followed by a list of arguments enclosed in parentheses.

Scalar functions may be nested within scalar functions or column functions, and column functions may be nested within scalar functions. See Rules for Scalar Functions for more information on nesting.

Following is the syntax diagram for scalar functions. This is CA Datacom/DB extension. For details, see the following:

►►─┬─┬─ DATE ────────┬─ (expression) ───────────────────────┬─────────────────►◄
   │ ├─ DAY ─────────┤                                      │
   │ ├─ DAYS ────────┤                                      │
   │ ├─ DIGITS ──────┤                                      │
   │ ├─ FLOAT ───────┤                                      │
   │ ├─ HEX ─────────┤                                      │
   │ ├─ HOUR ────────┤                                      │
   │ ├─ INTEGER ─────┤                                      │
   │ ├─ LENGTH ──────┤                                      │
   │ ├─ MICROSECOND ─┤                                      │
   │ ├─ MINUTE ──────┤                                      │
   │ ├─ MONTH ───────┤                                      │
   │ ├─ SECOND ──────┤                                      │
   │ ├─ TIME ────────┤                                      │
   │ ├─ VARGRAPHIC ──┤                                      │
   │ └─ YEAR ────────┘                                      │
   ├─ CHAR(expression ─┬────────┬─ ) ───────────────────────┤
   │                   ├─ ,ISO ─┤                           │
   │                   ├─ ,USA ─┤                           │
   │                   ├─ ,EUR ─┤                           │
   │                   └─ ,JIS ─┘                           │
   ├─ DECIMAL(expression ─┬───────────────────────────┬─ ) ─┤
   │                      └─ ,integer ─┬────────────┬─┘     │
   │                                   └─ ,integer ─┘       │
   ├─ SUBSTR(string,start ─┬───────────┬─ ) ────────────────┤
   │                       └─ ,length ─┘                    │
   ├─ TIMESTAMP(expression ─┬───────────────┬─ ) ───────────┤
   │                        └─ ,expression ─┘               │
   │                    ┌───────────────┐                   │
   ├─ VALUE(expression ─▼─ ,expression ─┴─ ) ───────────────┤
   ├─ character-functions ──────────────────────────────────┤
   ├─ bit-level-functions ──────────────────────────────────┤
   ├─ byte-level-function ──────────────────────────────────┤
   └─ xml-functions ────────────────────────────────────────┘