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.

Supported Uniface Database Utilities
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 Oracle and 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