Database Name

Database Name:
 
|--+-+-dbname--+---------------+-+-+----------------------------|
   | |         '-@dbservername-' | |
   | '-'//dbservername/--dbname'-' |
   |  (1)                          |
   '--------db_var-----------------'

Notes:

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.

3If the name of a database server is a delimited identifier 3or if it includes uppercase letters, that database server cannot participate 3in cross-server distributed DML operations. To avoid this restriction, 3use only undelimited names that include no uppercase letters when you declare 3the 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 IBM Informix GLS User's Guide.

Examples

You can choose a database on another database server as your current database by specifying a database server name. The database server that dbservername specifies must match the name of a database server that is listed in your sqlhosts information.

Database Name

Syntax

Usage

Examples