Database Name
Use the Database Name segment to specify the name of a database. Use this segment when you see a reference to a database name in a syntax diagram.
Syntax
- 1 ESQL/C only
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| dbname | Database name (with no pathname nor database server name) | Must be unique among the names of databases of the database server | Identifier |
| dbservername | Database server on which the database dbname resides | Must exist. No blank space can separate @ from dbservername. |
Identifier |
| db_var | Host variable whose value specifies a database environment | Variable must be a fixed-length character data type | Language specific |
Usage
Database names are not case sensitive. You cannot use delimited identifiers for a database name.
The identifiers dbname and dbservername can each have a maximum of 128 bytes.
If the name of a database server is a delimited identifier or if it includes uppercase letters, that database server cannot participate in cross-server distributed DML operations. To avoid this restriction, use only undelimited names that include no uppercase letters when you declare the name or the alias of a database server.
In a nondefault locale, dbname can include alphabetic characters from the code set of the locale. In a locale that supports a multibyte code set, keep in mind that the maximum length of the database name refers to the number of bytes, not the number of characters. For more information on the GLS aspects of naming databases, see the HCL OneDB™ GLS User's Guide.