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
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
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40