Function
identify objects.
Format
<user name> ::=
<usergroup name> ::=
<owner> ::=
<alias name> ::=
<column name> ::=
<constraint name> ::=
<index name> ::=
<reference name> ::=
<referential constraint name> ::=
<result table name> ::=
<sequence name> ::=
<synonym name> ::=
<termchar set name> ::=
<table name> ::=
<parameter name> ::=
<indicator name> ::=
<password> ::=
| <first password character> [<identifier tail character>...]
<first password character> ::=
| <language specific character>
| <digit>
Syntax Rules
1. All 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.
2. A <usergroup name> identifies a usergroup.
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.
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. An <index name> identifies an index created by a <create index statement>.
8. 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.
9. 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.
10. A <result table name> identifies a result table defined by a <query statement>.
11. A <sequence name> identifies a sequence which is generated by a <create sequence 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 <parameter name> identifies a host variable in an application containing SQL statements of ADABAS.
16. 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.