Function
identify objects.
Format
<user name> ::=
<usergroup name> ::=
<owner> ::=
| TEMP
<alias name> ::=
<column name> ::=
<constraint name> ::=
<domain name> ::=
<index name> ::=
<reference name> ::=
<referential constraint name> ::=
<result table name> ::=
<synonym name> ::=
<termchar set name> ::=
<table name> ::=
<db procedure> ::=
[<owner>.]<program name>.<procedure name>
<program name> ::=
<procedure name> ::=
<trigger name> ::=
<parameter name> ::=
<indicator name> ::=
<serverdb name> ::=
<servernode name> ::=
<password> ::=
| <first password character> [<identifier tail character>...]
<first password character> ::=
| <language specific character>
| <digit>
Syntax Rules
1. <servernode name>s are truncated after the 64th character. All the other names are truncated after the 18th character.
2. For parameter names, the conventions of the programming language in which the SQL statements of ADABAS are embedded determine the number of significant characters.
3. The <identifier>s for parameter names may contain the characters '.' and '-', but not as the first character.
Also valid are: <identifier>(<identifier>) and :<identifier> (.<identifier>.).
General Rules
1. A <user name> identifies a user. It is defined by a <create user statement>.
2. A <usergroup name> identifies a usergroup. It is defined by a <create usergroup statement>.
3. <owner> identifies the owner of an object. <owner> is the user name if the owner does not belong to a usergroup. <owner> is the usergroup name if the owner belongs to a usergroup. If TEMP is specified as <owner> in a <table name>, then a temporary table owned by the current user is concerned.
4. A new column name <alias name> defines the name of a column in a view table or in a snapshot table. It is defined in a <create view statement> or <create snapshot statement>.
5. A <column name> identifies a column. An identifier is defined as <column name> by a <create table statement>, <create view statement> , <alter table statement>, <create snapshot statement>, or in a <query statement>.
6. The name of a condition on rows of a table, <constraint name>, is defined in the <constraint definition> of the <create table statement> or <alter table statement>.
7. The name of a range of values, <domain name>, identifies a domain in a table column. It is defined by a <create domain statement>. The specification TEMP as <owner> made in a <domain name> is not valid.
8. An <index name> identifies an index created by a <create index statement>.
9. An identifier is declared to be a <reference name> for a certain scope and is associated with exactly one table. The scope of this declaration is the entire SQL statement. The same reference name specified in various scopes can be associated with different tables or with the same table.
10. A <referential constraint name> identifies a referential integrity rule which is created by a <referential constraint definition> in the <create table statement> or in the <alter table statement> defining delete or existence conditions between two tables.
11. A <result table name> identifies a result table defined by a <query statement>.
12. A <synonym name> is a designation for a table. This designation is only known for one user or usergroup. A <synonym name> is defined by a <create synonym statement> .
13. A <termchar set name> identifies a TERMCHAR SET defined by the ADABAS component CONTROL.
14. A <table name> identifies a table. An identifier is defined as <table name> by a <create table statement>, <create view statement> , <create snapshot statement>, or <create synonym statement>. ADABAS uses some <table name>s for internal purposes. The <identifier>s of these <table name>s begin with 'SYS'. To prevent conflicting names, it is recommended not to use <table name>s beginning with 'SYS'.
If the qualification of the user name is missing for a table name specification, first the partial catalog of the current user, then the partial catalog of the DBA who created the current user, and then the partial catalog of the SYSDBA of the current user is scanned for the specified table name. Finally, the partial catalog of the owner of the system tables is scanned, if required.
15. A <db procedure> identifies a DB procedure defined with the aid of an ADABAS component. The specification TEMP as <owner> made in a <db procedure> is not valid.
16. A <trigger name> identifies a trigger defined for a table with the aid of an ADABAS component.
17. A <parameter name> identifies a host variable in an application containing SQL statements of ADABAS.
18. An <indicator name> identifies an indicator variable in an application which can be specified together with a <parameter name> whose value indicates irregularities such as the occurrence of a NULL value or of different lengths of value and parameter.
19. A <serverdb name> identifies either the whole, non-distributed database or a part of the distributed database which was defined with the aid of the ADABAS component CONTROL.
20. The <password> is needed to establish the connection to the ADABAS server. The <password> of a user is defined by a <create user statement>. It can be altered by an <alter password statement>.