Configuring the DBMS Version
Supported DBMS versions
This list is given as a guide only. It is not intended to be an exhaustive list, and may change as new DBMS versions are released.
|
Product
|
Editor
|
Supported Versions
|
|---|---|---|
|
SQL ANSI
|
ISO 9075
|
1992
|
|
DB2
|
IBM
|
OS 390 V5 / OS 390 V7 / OS 390 V8
UDB V5 / UDB V7 / UDB V8
|
|
Ingres II
|
Computer Associates
|
2.0
|
|
Dynamic Server
|
Informix
|
7.3
|
|
Oracle
|
Oracle
|
8 / 9i / 10 / 11
|
|
SQL Server
|
Microsoft
|
7 / 2000 / 2005 / 2008
|
|
Adaptative Server
|
Sybase
|
11 / 12.5
|
|
Teradata Database
|
Teradata
|
14
|
|
PostgreSQL
|
PostgreSQL Global Development Group
|
9.3
|
Modifying DBMS version properties
Generation configuration is carried out to check the size of the identifiers generated, the characters authorized, etc.
To configure generation options of a DBMS version:
1. Search for the DBMS in question using the search tool.
2. Open its properties.
3. In the properties window of the DBMS, click the drop down list and select Options > Generation.
4. Modify the parameters you wish to change.
The parameters available vary as a function of the target DBMS. If the Generation subtab does not appear, select Tools > Options in the HOPEX bar, expand "Data Modeling SQL Generation" and check that the generation option linked to the DBMS concerned is selected.