Specifying fixed values in expressions.
Value specifications are values which are fixed within the context of one SQL statement. Value specifications are different to values derived from column contents, which can change as different rows or sets of rows are addressed.
The value specifications which may be used in expressions are:
- literals, see Literals
- parameter markers and host variables, see Parameter Markers and Host Identifiers, and Mimer SQL Programmer's Manual, Using Host Variables respectively.
- the keyword
USER, representing the name of a current ident (a national character varying string with maximum length 128). See SESSION_USER and CURRENT_USER respectively.
In the syntax diagrams, the term
value-specificationmay be replaced by the following construction:
This section summarizes standard compliance for value specifications.
Mimer Information Technology AB
Phone: +46 18 780 92 00