Value Specifications

---

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
• host variables, see the Mimer SQL Programmer's Manual, Using Host Variables
• the parameter marker character: ?, used in dynamic SQL, see the Mimer SQL Programmer's Manual, Principles of Dynamic SQL
• the keyword CURRENT_USER, SESSION_USER or USER, representing the name of the current ident (a national character varying string with maximum length 128).

In the syntax diagrams, the term value-specification may be replaced by the following construction:

Standard Compliance

This section summarizes standard compliance for value specifications.

Standard	Compliance	Comments
SQL-2011	Core	Fully compliant.
SQL-2011	Feature outside core	Mimer SQL Experience: Feature F561, "Full value expressions".

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se