Function
specifies a value.
Format
<extended value spec> ::=
| DEFAULT
| STAMP
<value spec> ::=
| NULL
| USER
| USERGROUP
| LOCALSYSDBA
| SYSDBA [(<user name>)]
| SYSDBA [(<usergroup name>)]
| DATE
| TIME
| TIMESTAMP
| TIMEZONE
| TRUE
| FALSE
<string spec> ::=
Syntax Rules
none
General Rules
1. The key word DEFAULT denotes the value defined as default for the column in the <create table statement> or <alter table statement>.
If such a value is not defined, the function DEFAULT is not allowed.
2. ADABAS is able to generate unique values. These consist of the SERVERDB number and of consecutive numbers counted for each SERVERDB. The consecutive numbers begin with X'000000000001'. The values are generated in ascending order. It cannot be ensured that a sequence of values is uninterrupted. The key word STAMP produces the next key which ADABAS generated on the HOME SERVERDB of the specified table. For a replicated table, STAMP produces the next key which ADABAS generated on the current SERVERDB. STAMP is allowed in an <insert statement> and in an <update statement> and can only be applied to columns of the data type CHAR(n) BYTE where n>=8.
If the user needs to know the generated value before applying it to a column, the <next stamp statement> must be used.
3. The key word NULL denotes the NULL value.
4. The key word USER denotes the name of the current user. If the user issuing the SQL statement belongs to a usergroup, then USERGROUP denotes the usergroup name, otherwise, the user name.
5. The key word LOCALSYSDBA denotes the SYSDBA of the SERVERDB where the current user has performed the <connect statement>.
The key word SYSDBA denotes the SYSDBA of the SERVERDB which is the HOME SERVERDB of the user <user name> or usergroup <usergroup name>. If neither a <user name> nor a <usergroup name> is specified, SYSDBA denotes the SYSDBA of the SERVERDB which is the HOME SERVERDB of the current user.
6. The key word DATE denotes the current date.
7. The key word TIME denotes the current time.
8. The key word TIMESTAMP denotes the current timestanp value which consists of date and time and microseconds.
9. The key word TIMEZONE denotes the time zone of the current SERVERDB. This value is currently preset to the value 0 and cannot be changed yet.
10. The key words TRUE and FALSE denote the corresponding values of Boolean columns.
11. For a <string spec>, only <expression>s that denote an alphanumeric value as the result are valid.
See also: