Function
identify objects.
Format
<user name> ::=
<usergroup name> ::=
<owner> ::=
<alias name> ::=
<column name> ::=
<reference name> ::=
<result table name> ::=
<schema name> ::=
<termchar set name> ::=
<table name> ::=
<parameter name> ::=
<indicator name> ::=
Syntax Rules
1. Names must not be longer than 18 characters.
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. It is defined in a <create view statement>.
5. A <column name> identifies a column. An identifier is defined as <column name> by a <create table statement>, <create view statement> , or in a <query statement>.
6. 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.
7. A <result table name> identifies a result table defined by a <query statement>.
8. A <schema name> identifies a schema generated by a <create schema statement>.
9. A <termchar set name> identifies a TERMCHAR SET defined by the ADABAS component CONTROL.
10. A <table name> identifies a table. An identifier is defined as <table name> by a <create table statement> or <create view 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.
11. A <parameter name> identifies a host variable in an application containing SQL statements of ADABAS.
12. 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.