Unqualified names are either regular names consisting of letters, digits and the underscore character that are not enclosed in double quotes, or special names, which must be enclosed in double quotes.
unqual_name ::= { regular_name | special_name }
regular_name ::= letter [ { letter | digit | _ } ] ...
special_name ::= " character... "
letter ::= a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z|
A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z
digit ::= 0|1|2|3|4|5|6|7|8|9
regular_name
Regular name, which is not enclosed in double quotes. A regular name cannot be a reserved SQL keyword (see section "SQL keywords").
letter
Lowercase letter between a and z or uppercase letter between A and Z of the SESAM/SQL character repertoire. Lowercase letters are automatically converted into uppercase letters. Umlauts cannot be used.
digit
Digit between 0 and 9.
_ Underscore character.
special_name
Special name, which must be enclosed in double quotes. A special name can be a reserved SQL keyword and can include special characters.
character
The first character cannot be the underscore character. Otherwise, you can use any printable character (i.e. >=X'40') in the SESAM/SQL character repertoire for character. A distinction is made between uppercase and lowercase letters. If character is the double quote character itself (X'7F'), it must be represented by two immediately adjacent double quotes. The pair of double quote characters is considered a single character.
Identical unqualified names
Two regular names are considered identical if, after the letters have been converted into uppercase letters, the characters at the corresponding positions in each name are identical.
A regular name and a special name are considered identical if, after the letters in the regular name have been converted into uppercase letters and the quotations have been removed from the special name, the characters at the corresponding positions in each name are identical. If the strings have different lengths, the shorter one is padded with blanks.
Two special names are considered identical if, after the quotations have been removed, the characters at the corresponding positions in each name are identical. If the strings have different lengths, the shorter one is padded with blanks.
Example
The following unqualified names are considered identical:
ABc abc "ABC" "ABC "
The following unqualified names are different:
Abc and "Abc"
"ABC" and "abc"
Identical names can be used interchangeably any time they occur.
The following names of database objects are unqualified names:
{ statement_id
|
authorization_identifier
|
catalog
|
cursor
|
unqual_base_table_name
|
unqual_constraint_name
|
unqual_index_name
|
unqual_routine_name
|
unqual_schema_name
|
unqual_space_name
|
unqual_stogroup_name
|
unqual_view_name
|
error_name
|
correlation_name
|
local_variable
|
label
|
routine_parameter
|
column }
::= unqual_name
statement_id
Name of a dynamic statement. The statement identifier must be unique within the compilation unit.
The statement identifier can be up to 18 characters long.
authorization_identifier
Name of an authorization identifier. The first 10 characters of the authorization identifier must be unique within the database.
If the name of the authorization identifier is specified without double quotes, it can include only letters and digits. If it is enclosed in double quotes, it must start with an uppercase letter and can only include uppercase letters, digits and the special characters “-” and “.”. The special characters cannot occur at the end of the significant part of the authorization identifier (the first 10 characters).
The strings “..”, “.-” and “-.” are not permitted.
The string “--” is permitted.
The authorization identifier can be up to 18 characters long.
catalog
Name of a database. If the name of the database is specified without double quotes, it can include only letters and digits. If it is enclosed in double quotes, it must start with an uppercase letter and can only include uppercase letters, digits and the special characters “-” and “.”. The special characters cannot occur at the end of the database name. The strings “..”, “.-” and “-.” are not permitted. The string “--” is permitted.
The database name may be up to 18 characters long.
cursor
Name of a cursor. A cursor name can only occur once in a DECLARE CURSOR statement within a compilation unit.
The cursor name may be up to 18 characters long.
unqual_base_table_name
Name of a base table. The unqualified name of a base table must be different from the other base table names and view names in the schema.
The unqualified base table name may be up to 31 characters long.
unqual_constraint_name
Name of an integrity constraint. The name must be different from the other integrity constraint names in the schema.
The unqualified name of an integrity constraint can be up to 31 characters long.
unqual_index_name
Name of an index. The unqualified index name must be unique within the index names of the schema.
The unqualified index name may be up to 18 characters long.
unqual_routine_name
Name of a routine. The unqualified routine name must be different from the other routine names in the schema.
The unqualified routine name may be up to 31 characters long.
unqual_schema_name
Name of a schema. The unqualified schema name must be unique within the schema names of a database.
The unqualified schema name may be up to 31 characters long.
unqual_space_name
Name of a space. The first 12 characters of the unqualified space name must be unique within the space names of a database. If the space name is specified without double quotes, it can include only letters and digits. If it is enclosed in double quotes, it must start with an uppercase letter and can only include uppercase letters, digits and the special characters “-” and “.”. The special characters cannot occur at the end of the significant part of the space name (the first 12 characters).
The strings “..”, “.-” and “-.” are not permitted.
The string “--” is permitted.
The unqualified space name may be up to 18 characters long.
unqual_stogroup_name
Name of a storage group. The unqualified name of the storage group must be unique within the storage group of a database. The unqualified name of a storage group can be up to 18 characters long.
unqual_view_name
Name of a view. The unqualified name of a the view must be different from the other base table names and view names in the schema.
The unqualified view name may be up to 31 characters long.
exception_name
Name of an exception or SQLSTATE in a COMPOUND statement.
All exception names in the COMPOUND statement must differ from each other.The exception name may be up to 31 characters long.
correlation_name
Rename a table.
The correlation name may be up to 31 characters long.
local_variable
Name of a local variable in a COMPOUND statement. The variable name must be unique in the COMPOUND statement and differ from all parameter names in the routine.
The variable name may be up to 31 characters long.
label
Name of a label in a routine. The label may not be identical to another label in the body statement.
Reserved keywords and the following names are not permitted as label names: ATOMIC, DO, ELSEIF, ITERATE, IF, LEAVE, LOOP, REPEAT, RESIGNAL, SIGNAL, UNTIL, WHILE.
The label name may be up to 31 characters long.
routine_parameter
Name of a routine parameter. The parameter name must be unique within the routine. The parameter name may be up to 31 characters long.
column
Name of a column. The column name must be unique within the table.
The unqualified column name may be up to 31 characters long.