The General tab displays information about the DBMS, including identifier case, character set values, delimiters, and separators.
The type and version of the database management system for the DB Alias. For example:
The default case for alphabetic characters used to identify database objects (for example, names of tables or views):
The character set that a DBMS interface uses to communicate with a client. Optim uses the Windows 95 or Windows NT code page to display or write data to a file. The DBMS interface uses a code page to pass data to Optim. In turn, Optim uses a code page to pass, insert, or update data through the DBMS interface.
In most cases, Optim identifies the code page and data received through the DBMS interface. As a result, any code page specified for the DB Alias is ignored. However, in some instances, the code page is not recognized (e.g., ODBC) and the DB Alias code page is used.
To enter the DB Alias code page, click the arrow to select from a list of valid character set values. Supported code pages are:
Code Page | Character Set |
---|---|
437 | U.S. English |
850 | International Multilingual |
860 | Portuguese |
863 | Canadian, French |
865 | Nordic |
1250 | Eastern European |
1251 | Cyrillic |
1252 | U.S./Western European ANSI or Latin 1 (ISO 8859-1) |
1253 | Greek |
1254 | Turkish |
1255 | Hebrew |
1256 | Arabic |
1257 | Baltic Rim |
blank | Windows 95 or Windows NT |
Optim expects to use the following, depending on the DBMS:
DBMS | Code Page |
---|---|
DB2 | DB2CODEPAGE environment variable. If not found, the Windows code page is used. |
Oracle | Oracle Character Set Name (as defined in the Oracle Windows Registry entries). If not found, the DB Alias code page is used. |
Sybase ASE | Sybase Locale Character Set Name (as defined to the Sybase ASE client). If not found, the DB Alias code page is used. |
SQL Server | Windows code page. |
Informix | Windows code page. |
The delimiter used to enclose strings that contain special characters or blanks, either single quotes (‘ _ ‘) or double quotes (“ _ ”).
The separator character needed to designate the decimal point in numeric strings. Select the character that is appropriate for the DBMS:
Separator | Example |
---|---|
Comma ( , ) | 1,50 |
Period ( . ) | 1.50 |
Space ( _ ) | 1_50 |
Select this option if the Optim™ Directory resides in the database indicated by the DB Alias. The Optim Directory, created when Optim is installed, holds internal system tables and any objects you create using Optim. Several databases can use the same Optim Directory. Access Definitions and other objects stored in the Directory can be shared.
Indicates whether Optim is configured to require a password for the DB Alias. You can change this setting using the Configuration program. For details, see the Installation and Configuration Guide .