Value specifications are values which are fixed within the context of one SQL statement (as distinct from values derived from column contents, which may change as different rows or sets of rows are addressed).
The value specifications which may be used in expressions are:
- literals, see Literals
- host variables, see the Mimer SQL Programmer's Manual
- the keyword CURRENT_USER, SESSION_USER or USER, representing the name of the current ident (a varying character string with maximum length 128 bytes)
- the parameter marker character ("?"), used in dynamic SQL, see the Mimer SQL Programmer's Manual.
In the syntax diagrams, the term value-specification may be replaced by the following construction:
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40