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, chapter 7, Using Host Variables
- 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, chapter 11, Principles of Dynamic SQL.
In the syntax diagrams, the term value-specification may be replaced by the following construction:
This section summarizes standard compliance for value specifications.
X/Open-95 SQL-92 YES Fully compliant.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40