Create Database Wizard
Use this wizard to create a database and to specify the database locale.
Prerequisite: To
create a database, the OpenAdmin Tool (OAT) for Informix® requires IBM®
Informix 11.70.xC2
or later.
- Database name
- Type a name for the database that is unique among the names of databases of the database server. The name must follow the guidelines of SQL syntax for an identifier.
- Dbspace
- Specify the dbspace to store the data by selecting it in the list of dbspaces. The default is the root dbspace.
- Locale (DB_LOCALE)
- Optional. Specify the locale for the database by selecting it in the list of locales. The list contains the locales that are installed on the database server. If the locale is not specified, the default English locale is used. The database server uses the database locale to process locale-sensitive data.
- Logging mode
- Specify the log-buffering mechanism that the database uses for transaction logging: buffered, unbuffered, or ANSI-compliant, or no logging.
- Character case
- Specify whether the database is case-sensitive. A database that is not case-sensitive does not distinguish between uppercase letters and lowercase letters in the data types NCHAR and NVARCHAR when you search or query the data.