Supported Uniface Database Facilities
Uniface provides facilities for working with databases:
- Create Table —generates SQL command scripts needed to build the database tables in the supported DBMS based on definitions in the application model. For more information, see Create Table Facility and /genSql.
- Create Script—generates DBMS-specific SQL scripts for maintaining referential integrity in the DBMS. The scripts map relationships defined in the application model to declarative constraints and database triggers in the database. For more information, see Create Script Facility and /genSql.
- Load Definitions— load database table definitions from the data dictionary of the selected DBMS into the Uniface model. This enables you to create an application model based on an existing database. For more information, see Load Definitions Facility.
Support for these utilities depends on the database connector.
| Connector | Create Table | Create Script | Load Definitions | Details (where applicable) |
|---|---|---|---|---|
| DB2 | Yes | No | Yes | For more information, see Create Table Facility for DB2, Load Definitions Facility for DB2, and Load Definitions Facility for DB2 on iSeries. |
| Informix | Yes | Yes | Yes | For more information, see Referential Integrity Management on Informix |
| LDAP | No | No | No | |
| MS SQL Server | Yes | Yes | Yes | For more information, see Enable Referential Integrity in a Microsoft SQL Server Database and Load Definitions for Microsoft SQL Server |
| MySQL | Yes | No | Yes | |
| ODBC | No | No | No | |
| Oracle | Yes | Yes | Yes | For more information, see Create Table Facility for Oracleand Load Definitions for Oracle |
| PostgreSQL | Yes | Yes | Yes | For more information, see Load Definitions for PostgreSQL. |
| Sequential | No | No | No | |
| SQLite | Yes | No | Yes | For more information, see Load Definitions Facility for SQLite |
| Sybase | Yes | Yes | Yes |
For more information, see Create Table Facility for Sybase. |
| Text | No | No | No |
