Function
specifies a location in a key-listed table.
Format
<key spec> ::=
Syntax Rules
1. The <value spec> must not be the NULL value.
General Rules
1. The <column name> must denote a key column of the table.
2. The key specification must contain all key columns of a table. The <key spec>s are separated by a comma.
3. The key specification indicates a location in a key-listed table, without requiring the existence of a row of the specified key values.
4. For tables created without key columns, there is the implicitly created column SYSKEY CHAR(8) BYTE which contains a key generated by ADABAS. This column can only be used in a <key spec>.